Special Heatmap

[powerbityro]

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.

[amitchandak]

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 Linkedin

[powerbityro]

hi amitchandak,

good idea but I don't see a chance for a conditional formatting for the subcategories. I need a heatmap. 

[v-lid-msft]

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,

[powerbityro · Accepted solution]

It worked. Many thanks!