Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data visualization challenge

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 typeIndicator 1Indicator 2Indicator 3Indicator 4Indicator 5Indicator 6Indicator 7Indicator 8Indicator 9Indicator 10
1APassPassFailPassFailPassFailFailPassPass
2AFailPassFailPassFailPassFailPassFailPass
3APassPassFailPassFailPassFailPassPassPass
4AFailPassFailPassFailPassFailPassFailPass
5AFailPassFailPassFailFailFailFailFailPass
6BPassPassPassPassFailPassFailPassPassPass
7BFailPassFailPassFailPassFailPassFailPass
8BPassPassPassPassFailPassPassPassPassPass
9BFailPassFailPassFailPassFailFailFailPass
10BFailPassFailPassFailFailPassPassFailPass
11CFailPassFailPassFailFailPassPassFailPass
12CFailPassFailPassFailFailPassPassFailPass
13CFailPassFailPassFailFailPassPassFailPass
14CFailPassFailPassFailFailFailFailFailPass
15CFailPassFailPassFailFailPassPassFailPass
16DFailPassFailPassFailFailPassPassFailPass
17DPassFailPassPassFailFailPassPassPassFail
18DFailFailFailPassFailFailFailPassFailFail
19DPassFailPassPassFailFailFailPassPassFail
20DFailFailPassPassFailFailPassPassFailFail

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!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

3 Replies