cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Heatmap visual

Hi all,

 

I have an question about an visual that I'm trying to create. I have two different tables that are connected with the date field. The first table is a simple calander table with just the regular items in it. The most important items for this visual are the items below.

Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

 

The second table is also not that difficult and looks like this. I have shortend this table a little bit because otherwise it will be to long for this post. The table contains for each hour each day a number.

DateNumberTime
29/07/20202310:00 AM
29/07/20205311:00 AM
29/07/202021312:00 PM
29/07/202075401:00 PM
29/07/20202302:00 PM
29/07/202065703:00 PM

 

With these two tables I can create a heatmap visual where I can display each day of the week (mon, tue, wed...) with the hours and the count of each hour. It will look something like this. 

Day10:00 AM11:00 AM12:00 PM
Mon123432124
Tue4351235664
Wed752213342

 

I have colorised each number field based on the percentage of the amount. So the field will be green when the amount is below 33%, orange if it is between 33% and 67% and red when above 67%.  I hope you can still understand my story.. 

But now comes the tricky part, I want to set some specific field on another color (for example black). This is not correlation to the amount of the number field but based on the day and time. But because these are two seperate tables and I already put an color filter based on the number field I do not know how to set a color filter based on that specific measure.

 

I hope that I'm clear enough and you can understand me. I'm sorry for my bad english and maybe some typeerrors. If you have questions please ask! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

@JeroenR , I doubt you can do conditional formatting in heat map with with axis and legend



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@JeroenR , I doubt you can do conditional formatting in heat map with with axis and legend



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

@amitchandak thank you for your reply.


I was also afraid of that, but I thought I would ask it just to be sure here on this forum. Maybe there was someone who had a crazy but working idea.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors