Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Exclude one category from a ranking

Good Morning to everyone,

 

I have the following visual:

 

captura.png

 

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

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

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

View solution in original post

1 REPLY 1
Shaurya
Memorable Member
Memorable Member

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.