Data visualization challenge

[sarah-931]

Hello,

I have the following dataset, and I'm aiming to visualize it in the most intuitive way. I want to display the percentage of failed products for each product type per every indicator, with the option to filter by a specific product type or view all products types in the graph.

Serial Number	Product type	Indicator 1	Indicator 2	Indicator 3	Indicator 4	Indicator 5	Indicator 6	Indicator 7	Indicator 8	Indicator 9	Indicator 10
1	A	Pass	Pass	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass
2	A	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass
3	A	Pass	Pass	Fail	Pass	Fail	Pass	Fail	Pass	Pass	Pass
4	A	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass
5	A	Fail	Pass	Fail	Pass	Fail	Fail	Fail	Fail	Fail	Pass
6	B	Pass	Pass	Pass	Pass	Fail	Pass	Fail	Pass	Pass	Pass
7	B	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Pass
8	B	Pass	Pass	Pass	Pass	Fail	Pass	Pass	Pass	Pass	Pass
9	B	Fail	Pass	Fail	Pass	Fail	Pass	Fail	Fail	Fail	Pass
10	B	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
11	C	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
12	C	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
13	C	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
14	C	Fail	Pass	Fail	Pass	Fail	Fail	Fail	Fail	Fail	Pass
15	C	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
16	D	Fail	Pass	Fail	Pass	Fail	Fail	Pass	Pass	Fail	Pass
17	D	Pass	Fail	Pass	Pass	Fail	Fail	Pass	Pass	Pass	Fail
18	D	Fail	Fail	Fail	Pass	Fail	Fail	Fail	Pass	Fail	Fail
19	D	Pass	Fail	Pass	Pass	Fail	Fail	Fail	Pass	Pass	Fail
20	D	Fail	Fail	Pass	Pass	Fail	Fail	Pass	Pass	Fail	Fail

I attempted to create a different measure for each indicator and use it in a stacked bar chart. The Y-axis represents the product type, and the X-axis consists of the 10 different indicator measures. However, I find the graph difficult to read and not very intuitive.

Here are the DAX formulas for the percentage of failed indicators:

Indicator-1 =
CALCULATE(COUNT('Table'[Serial Number]), 'Table'[Indicator 1] = "Fail") /
COUNT('Table'[Serial Number])

Indicator-2 =
CALCULATE(COUNT('Table'[Serial Number]), 'Table'[Indicator 2] = "Fail") /
COUNT('Table'[Serial Number])

... Repeat for other indicators ...

 If you have any creative ideas, please share them. Thank you!

[sarah-931 · Accepted solution]

I was able to get this done using Radial Bar chart, I downloaded it and used it. I had 10 radial bar charts for each one of the indicators. Below I am showing the chart for indicator 1 only.

[amitchandak]

@sarah-931 , better to unpivot this table and have indicator on row. That will give a better model to solve the problem

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s


You can use stacked visual

[sarah-931]

Hey @amitchandak , it will be hard to unpivot the table because the actual data has millions of rows and around 12 indicators out of 75 existing columns.