Forum Discussion

Helper II

6 years ago

Solved

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...

Need Help

powerbityro
6 years ago
It worked. Many thanks!

v-lid-msft

Community Support

6 years ago

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)