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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

graphing temperature changes overtime

Hello! 

 

I am attempting to re-create a chart that I have previously made in excel in powerBI. In excell i simply used conditional formatting to change the color of each cell according to the size of the data value in that cell. Therefore before I spend too much time pulling my hair out trying to figure this out I was wondering if anyone had 1. A recommendation for a custom visual to use, 2. A recommendation for using conditional formatting within powerBI 

 

Anything helps, thanks!!

 

Austin I 

1 ACCEPTED SOLUTION

Oh, you want to add the date hierarchy to the columns or create your own based on Month and then Day. Then use the forked arrow drill down to drill down the column to the day level.

 

My example will show you how to eliminate the actual numeric values so that you get something more like your original chart picture.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

The table and matrix visuals support conditional formatting. Works like Excel. Use the drop down arrow in the Values area to apply conditional formatting.

 

An example of what you are trying to recreate would be helpful.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

So I have gotten this far with the conditional formatting!  But I would like to, if possible, not aggregate the total monthly data but instead have each day for each month on the top x-axis and have not been able to arrange that yet. 

 

Weather4.PNG

Oh, you want to add the date hierarchy to the columns or create your own based on Month and then Day. Then use the forked arrow drill down to drill down the column to the day level.

 

My example will show you how to eliminate the actual numeric values so that you get something more like your original chart picture.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I will take a look. Thanks a bunch for your help Greg! 

Anonymous
Not applicable

YES I totally forgot to attach a picture! ....lmk if you need better photos!

 

final outcomefinal outcomeDatasetDataset

I kind of broke my cardinal rule about asking people to supply text data that can be copied because I was interested in this. Seems like you can create this via a blank column and a conditional formatting based upon a measure. See attached PBIX. This is my working copy as I solve problems on the forum so it has a bunch of stuff you don't want. Look at Page 6 and Table 15.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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