Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Conditional Format: Majority of the Average

I have a matrix table, showing a variety of projects. Across the top is months. You can filter down through the projects to sub projects. Each project has a impact rating, red, amber, green (3,2,1). ...
conditional format
DAX
majority of average
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the response.

     

     

    So the area (on the left) and their project impact the team on the right. 

    I want to summarise by month and total area but the number needs to be MODE. I want the most frequent team impact number as the number across.

     

    Dummy data included.

     

    So the summary would look something like this;

     

    And then I can apply conditional formatting to form a heat map of impacted teams. 

     

    Letting PBi summarise the total data, leaves you with a SUM or Count of the impact numbers and I don't want that. 

     

    Hope this makes sense.