cancel
Showing results for
Did you mean:
Helper II

How to display individual values in a matrix visual

The number of "Colors" is counted for each "Time". There are two types of "Color", "Blue" and "Red", and the number of each color obtained is displayed.

It's easy enough to just count the number of colors, but I want to show the percentage of Blue out of the total number as well, as shown in the image below.

This is a sample, but it uses this data.

When I set the measure to value with the percentage calculated as a test, it is also displayed for Red and Totals.
How can I display only the percentage for Blue?

I think this can be reproduced in a table visual by creating a measure with 4 (count columns by color + total column + percentage column for blue only) * 2 (number of types of Times) = 8.

However, this is not very realistic as we plan to increase the number of colors and the number of Times, such as 3rd.

If anyone knows of a better way to do this, could you please let me know?

Best regards, Lopez

1 ACCEPTED SOLUTION
Super User

Hi @Lopez0090 ,

You can create a seperate measure for "# of Blue","# of Red","% of Blue"  like below and take direct sum of Count for total

``# of Blue = CALCULATE(sum(Table[Count]),FILTER(Table,Table[Color] = "Blue"))``
``# of Red = CALCULATE(sum(Table[Count]),FILTER(Table,Table[Color] = "Red"))``
``% of Blue = divide(Table[# of Blue],SUM(Table[Count]),0)``

Output:-

Thanks,

Samarth

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

Super User

Hi @Lopez0090 ,

You can create a seperate measure for "# of Blue","# of Red","% of Blue"  like below and take direct sum of Count for total

``# of Blue = CALCULATE(sum(Table[Count]),FILTER(Table,Table[Color] = "Blue"))``
``# of Red = CALCULATE(sum(Table[Count]),FILTER(Table,Table[Color] = "Red"))``
``% of Blue = divide(Table[# of Blue],SUM(Table[Count]),0)``

Output:-

Thanks,

Samarth

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

Announcements

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors