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

[vin26]

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 summarized table/matrix based on the selected slicers by grouping colors, like below table:

Please help me with the solution.

[v-jayw-msft]

Hi @vin26 ,

Are the measure1 and measure2 the counts of selected rows and selected columns?

Best Regards,

Jay

[vin26]

@v-jayw-msft  Hi Jay,

Thank you for the response, you may ignore the measures, I would like get the sum of each color like below or in any format would help:

[v-jayw-msft]

Hi @vin26 ,

I see, you want calculate the sum of value for each color based on the slicer right?

I can see we have already get color for each unit, I'm guessing if we can create a table have a column with color in rows.

Then use like sumx(martix[value],color_measure=selectedvalue(new_table[color])) to get the sum value for each color.

Can you share some sample data so that i can do some test?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vin26]

Hi @v-jayw-msft please let me know if you got any idea to solve the issues. 

[vin26]

Hi @v-jayw-msft 

Yes, you are right!.

Please find the sample file in https://community.powerbi.com/t5/Developer/Apply-Colors-to-selected-range-in-matrix/m-p/1074834  in which @v-lid-msft has done a sample file to get the colors.

[amitchandak]

@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[vin26]

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