Forum Discussion
Displaying cards based on top 2 value dynamically
Hi guys, I am facing a challenge in displaying two card visual. I have four columns in my dataset i.e Division, category, manufacturer and sales. Division and category will be the slicers in ...
Anonymous
To exclude M1 from the rank, use:
Manuf. Rank = VAR _RANK= RANKX( FILTER(ALLSELECTED('Fact Table'), 'Fact Table'[Manufacturer] <> "M1"), [Sum Sales],,DESC,Dense) RETURN IF(ISINSCOPE('Fact Table'[Manufacturer]), _RANK) // To Exclude from the "Total" rowCreate your matrix, and exclude M1 in the filter for Manufacturer in the filter pane, and set the rank to "less than 3"
I've included the PBIX file for you to check out.
Anonymous , As per what I got
you can create a rank
Total sales = sum(Table[Sales])
Rank = RankX(allselected(Table[Manufacturer]),[Total sales])
You can append and show Manufacturer and sales. or you can put the Manufacturer on one card and sales on another. The filter then Rank =1 . And use a group card to show them together
same for Rank 2
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-visuals
top Manufacturer
maxx(filter(Values(Table[Manufacturer]),[Rank]=1),Table[Manufacturer])