Formatting help with heatmap

[BrianJ]

@talk2gwhite,

I think I can help you with all three of these questions:

1. I would do this with a toggle visual tied to a page navigation button action. Basically, build your page the way you want for the agency goal, then duplicate that page and change the relevant measures, column references, etc. to align with the MOP goal. Have the switch/toggle visual in one position for the first goal and in the opposite position on the second page for the other goal. Then set your page navigation button click to bring you to the other page.

It’s much easier than it sounds - take a look at my Data Challenge #4 entry PBIX file - I used this technique to toggle between the table view and the chart view.

@sam.mckay did a video explaining this technique in detail:

3 Visualization Tips You Can And Should Use In Your Power BI Reports

2. Custom legend – another great video from Patrick at GIAC on how to do this:

Want a custom LEGEND for your Power BI visual? WATCH THIS!

3. Building attractive color themes:

I wrote a long post about this earlier this summer, which I think is a good place to start since it references a bunch of excellent resources for color theme generation:

What layout/schemes do you like using?

@Keith, In terms of color themes, I really like the following: With regard to the color theme generator, you can’t go wrong with the color fan. I’ve also generated some nice schemes using the image to colors. For example, here’s an image I used recently to generate what I thought was a color scheme that worked well: [image] With regard to layouts, I don’t think you can do better than to look through the entries for the three recent Enterprise DNA Data Challenges. There are some absolut…

Sam also did an excellent video on this topic earlier this week:

Why Using Good Colours Across Your Reports Is Essential In Power BI

I hope this is helpful. Please let me know if you have any questions about the above.

• Brian

P.S. You and I should talk off-line at some point – it sounds like we do some very similar things within the Federal Government, and I’ve been building a number of reports addressing the same HR/process tracking issues.