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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashaikh
Helper III
Helper III

RANKX on a column when I have legend for column chart

Hello,

 

I am creating a column chart. The column chart includes Location on Axis, Count of Ticket Number on Value, and Priority on Legend.  It looks like this - 

1.PNG

 

 

2.PNG

  

 

Here I want to view just Top 10 location based on Ticket Number. I can use below formula for that.

 

RANK LOCATION TICKET = IF(NOT(ISBLANK(tblNORTHWELL[TICKET COUNT])), RANKX(FILTER(ALL(tblNORTHWELL[Location]), tblNORTHWELL[TICKET COUNT]), tblNORTHWELL[TICKET COUNT], , ,Skip), BLANK())

 

This formula works perfectly when I don't Priority in Legends but when I include Priority it shows me all the records.

Can you please suggest a solution to include that.

 

Thanks

Abdul

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@ashaikh

 

Hi, Could try using TopN in Visual Filter.

 

TOPN in Visual Level FilterTOPN in Visual Level Filter




Lima - Peru

View solution in original post

1 REPLY 1
Vvelarde
Community Champion
Community Champion

@ashaikh

 

Hi, Could try using TopN in Visual Filter.

 

TOPN in Visual Level FilterTOPN in Visual Level Filter




Lima - Peru

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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