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
NCW
Frequent Visitor

Conditional Formatting with Cards to Make a Heatmap

I have a physical seating chart of computers and I am logging the seats that are used the most. I have come up short of standard heatmaps and other map visuals. So, I created the layout with Cards and I applied a conditional format to them on the number of hours they were used. Shown below on the left is the layout with formatting applied and on the right is the table of values also with conditional formatting.

NCW_0-1700239728637.png

The problem I am having is that when applying conditional formatting to the cards, I am forced to enter a static value for High/Med/Low unlike the table of values. Is there a way to make the cards have a dynamic formatting as the numbers increase?

 

(Formatting)

NCW_1-1700239873749.png

Thanks!

2 ACCEPTED SOLUTIONS

Use your preferred Choropleth map creation tool.  Then use a visual like Deneb to show it.

 

Choropleth of Unemployment Rate per County | Vega-Lite

View solution in original post

NCW
Frequent Visitor

I ended up using the Synoptic Panel visual and a custom floorplan that I quickly made.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

 

So, I created the layout with Cards

 

You get extra points for creativity.  But maybe you want to consider proper Choropleth map visuals instead.

NCW
Frequent Visitor

Do you know of a way I can create a custom map and implement it with my layout and data?

Use your preferred Choropleth map creation tool.  Then use a visual like Deneb to show it.

 

Choropleth of Unemployment Rate per County | Vega-Lite

NCW
Frequent Visitor

I ended up using the Synoptic Panel visual and a custom floorplan that I quickly made.

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.

Top Solution Authors