Forum Discussion
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...
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.
Anonymous , 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
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.