Forum Discussion
Special Heatmap
Hi all,
I am looking for a heatmap in the following structure:
Does someone know if that structure is possible in Power BI?
For example A has the subcategories 1-13. The first 1-5 subcategories are presented in the first five cells and than in a new row so that all is more compact and you dont neet to scroll to right. At the moment I use a Matrix with conditional formatting with background color but this design is not possible.
Many thanks.
It worked. Many thanks!
4 Replies
A heat map with three fields, I doubt. But if you explore other maps. Explore Sun Brust
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380767?tab=Overview
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedinhi amitchandak,
good idea but I don't see a chance for a conditional formatting for the subcategories. I need a heatmap.
Hi powerbityro ,
We can try to create two calculated column and use condition format to meet your quirement:
Row Control = ROUNDUP(RANKX(FILTER('Fact Table','Fact Table'[Category] = EARLIER('Fact Table'[Category])), [Sub Category],,ASC,Dense) / 5,0)Column Control = RANKX(FILTER('Fact Table',[Category] = EARLIER('Fact Table'[Category]) && 'Fact Table'[Row Control] = EARLIER('Fact Table'[Row Control])), 'Fact Table'[Sub Category],,ASC,Dense)
Best regards,
