Forum Discussion

powerbityro's avatar
powerbityro
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's avatar
    powerbityro
    6 years ago

    It worked. Many thanks!

amitchandak's avatar
amitchandak
Super User
6 years ago

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's avatar
powerbityro
Helper II
6 years ago

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's avatar
    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)

     

     


    Best regards,

     

    • powerbityro's avatar
      powerbityro
      Helper II
      6 years ago

      It worked. Many thanks!