Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to display top 10 Products for the Year on the cards and it changes randomly so I have created a Rank Measure but i am unable to use under visual filter and add the Category/Product Name as well. Any idea
Solved! Go to Solution.
Hi @PK_PBIBoss
Add measures in card visuals
rank = RANKX(ALLSELECTED('Table 2'),CALCULATE(SUM('Table 2'[sale])),,DESC,Dense)
top1 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=1))
top2 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=2))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Drag the Rankx measure to the filter section and select Less than equal to 10. Create a Table visual and drag products and revenue there.
I know Table filters work but for Card the Visual filter does not work with the Measure.... As I need to place 10 cards and it needs to change dynamically as per the year basis and matrix dont give the same impact.....
@PK_PBIBoss , try Top N
https://databear.com/power-bi-dax-topn-function/
Thanks for responding @amitchandak but that is also a measure that will not work in the chart visual filter.... I want to place 10 cards each displaying one rank ( i.e. Rank 1 or Rank 2 or Rank3 ...) and once the year slicer is change these chart change the products accordingly....
Hi @PK_PBIBoss
Add measures in card visuals
rank = RANKX(ALLSELECTED('Table 2'),CALCULATE(SUM('Table 2'[sale])),,DESC,Dense)
top1 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=1))
top2 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=2))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |