Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Exclude one category from a ranking

Good Morning to everyone,   I have the following visual:     The visual above is composed by a graphic on the left and a table on the right. The table and the bar plot show a 'Group' ranki...
Need Help
Tips and Tricks
  • Shaurya's avatar
    Shaurya
    3 years ago

    Hi Anonymous,

     

    You can filter the table that you pass as parameter for RANKX function. Use:

     

    Rank = RANKX(FILTER(Table,'Table'[Category]<>"Market"),'Table'[Premiuns],,DESC)

     

    Use this Rank in both the visuals now. Use visual level filters to exclude the values, that are blank, in the bar chart but not in the table visuals. That way, Market will appear in the table but without a rank and not appear in the chart at all.

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Anonymous,

 

You can filter the table that you pass as parameter for RANKX function. Use:

 

Rank = RANKX(FILTER(Table,'Table'[Category]<>"Market"),'Table'[Premiuns],,DESC)

 

Use this Rank in both the visuals now. Use visual level filters to exclude the values, that are blank, in the bar chart but not in the table visuals. That way, Market will appear in the table but without a rank and not appear in the chart at all.

 

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI