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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pipe07
Frequent Visitor

Visual object

Hello community, I need your valuable help. Question: is there any visual object in PowerBI that allows me to make a graph like the one I put in the following image? it is a graph that shows the position in a ranking of a University against others, according to some defined categories, any idea? (don't pay attention to the "Top Rank in Country" number), Thanks a lot!

 

pipe07_0-1631681352710.png

 

1 REPLY 1
amitchandak
Super User
Super User

@pipe07 , This kind of hydrid display.

 

For the part. We can create a series and use that on column

 

Assume you have rank measure  = [Rank]

 

Series = generateseries(1,20,1)

 

New Color measure =  if([Rank] = Max(Series[Value]) , "Yellow", "white")

 

Make sure matrix column is series[value] and use conditional formatting (field value) to color the background using color measure

 

To make it hybrid

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors