Forum Discussion
clustered column chart with category
Hello,
I want to represent count based status in my approval status cloumn. Let's say this column have 4 different statuses, I want each status to be represented in the chart.
In power by, I have a column status but when doing a count, I get one bar in the chart representing the total. I have tried creating count by status, count filtered...all got back to
Hi Anonymous ,
You can try to create a table with a Status column.
Create a measure, use the Switch() function to determine which state gets the corresponding value, then place [Status] on the X-axis and [Measure] on the Y-axis.
If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- parry2k
Super User
Anonymous what are you using on the x-axis and value well of the visual?
Hi Anonymous ,
You can try to create a table with a Status column.
Create a measure, use the Switch() function to determine which state gets the corresponding value, then place [Status] on the X-axis and [Measure] on the Y-axis.
If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
