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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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