Forum Discussion

vin26's avatar
vin26
Icon for Resolver I rankResolver I
6 years ago

Summarizing the values based on the multiple slicer selections which are not conned to the table

Hello,   I have created a matrix by using below link: https://community.powerbi.com/t5/Developer/Apply-Colors-to-selected-range-in-matrix/m-p/1074834    Now, my requirement is to create a summar...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

vin26 , Not sure I got it, But you can use "Show on row" in Matrix, which will move Measure on the row. And do not give anything on Row and give color on the column

Refer

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

 

For formatting

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

  • vin26's avatar
    vin26
    Icon for Resolver I rankResolver I
    6 years ago

    amitchandakthank you for the quick response, I have already created the conditional formatting, like in above link. To make the color change I have used 10 slicers which are not connected to the data table. Coloring the matrix is working fine, but I am unable to get a sum of those colors, I would need to sum up those colored range.