Exclude one category from a ranking

[Anonymous]

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' ranking based on the value of a column called 'Premiums'. However, inside the field 'Group' there is a category that I don't want to participate in this ranking. The category is 'Market'. In this sense, the column 'RNK' should not show any value for the group 'Market' but still it should appear. On the other side, the category 'Market' should not be displayed in the bar plot (never). 

How could I do this?

Thanks in advance

[Shaurya · Accepted solution]

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