Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

final outcomeDataset

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.