Forum Discussion
Resolver ISummarizing 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 summarized table/matrix based on the selected slicers by grouping colors, like below table:
Please help me with the solution.
7 Replies
- amitchandak
Super User
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
vin26amitchandakthank 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.
Hi vin26 ,
Are the measure1 and measure2 the counts of selected rows and selected columns?
Best Regards,
Jay
- vin26
Anonymous 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:
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.
