Articles in this section

Power BI: How to Filter Pursuits by Smart Fields

Avatar
Olivia Hardy
  • Updated
Follow

This applies to:

 

 

 

 


Hub Central

 

Available with the following QorusDocs Editions:

Enterprise
Premium
Essential
Free

1. mceclip0.png

2. Click on Pursuit Smart Fields Query mceclip2.png

 

3. Select Column: FieldDisplayName

mceclip3.png

 

4. Under Transform, click Pivot Column

 

mceclip4.png

 

5. Under Values Column, select FieldValue. Under Advanced options, select Don't Aggregate. Click OK.

 

mceclip6.png

6. Under Home, click Close & Apply mceclip7.png

7. Navigate to Data Model mceclip8.png

 

8. Double click on the relationship between Pursuit Smart Fields and Pursuits

mceclip9.png

9. Configure the relationship as follows:

mceclip10.png

10. Unselect "Hide in Report View" mceclip11.png

 

Watch video below:

 

 

Related articles

Comments

0 comments

Please sign in to leave a comment.