cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
ronaldbalza2023
Continued Contributor
Continued Contributor

Table Heat Map - Weekday

Hi everyone, does anyone know how can I achieve this heatmap by weekday? Thanks and much appreciated 🙂

ronaldbalza2023_0-1654125771128.png

 

1 REPLY 1
dhruvinushah
Responsive Resident
Responsive Resident

Hi @ronaldbalza2023 , 
You can do this using a Matrix visual. 
Use Weeks as Rows, DayOfWeek as Columns and your Value field in the Values section. 
Set up conditional formatting using your business logic for the background colors per the image shown. 

Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!









Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors