cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Help using column data for comparison charting

Hi all,

 

I'm trying to get my head around how to structure my data in order to visualize it properly. I've two columns in my dataset that I want to compare: Recommended, Final Decision. Each entry in the columns is one of three types: Buy, Sell, Defer. I'm looking to create a chart to compare the Recommended Vs. Final Decision for these entries. I can make three separate pie charts to show the breakdown of this for each individual entry type, but this isn't ideal. It's fine for a quick overview, but falls apart (in terms of being confusing to interpret) when you start looking at specific subsets (user breakdown).

 

I'm looking to plot the data in a Clustered Bar Chart, where I can have {"Buy", "Sell", "Defer"} on the Y-Axis and the Count of entries for each in terms of Recommended and Final Decision on the X-Axis. I've been trying it myself, but for some reason the Count shows the same value for Recommended and Final Decision (e.g. there's 32 Recommended "Buy" entries and 23 Final Decision "Buy" entries but both bar chart entries show 32).

 

Can anybody point me in the right direction? I'm sure I'm just missing something simple.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Got it working with the addition of 2 measures:

Followed Recommendation = COUNTROWS(filter('Table',[Final Decision]=[Recommended]))

Didn't Follow Recommendation = COUNTROWS(filter('Table',[Final Decision]<>[Recommended]))

Was then able to plot these on Stacked and Clustered Bar Charts and they were grouped as expected (with Recommended used for axis).

View solution in original post

2 REPLIES 2
Highlighted
Frequent Visitor

Got it working with the addition of 2 measures:

Followed Recommendation = COUNTROWS(filter('Table',[Final Decision]=[Recommended]))

Didn't Follow Recommendation = COUNTROWS(filter('Table',[Final Decision]<>[Recommended]))

Was then able to plot these on Stacked and Clustered Bar Charts and they were grouped as expected (with Recommended used for axis).

View solution in original post

Highlighted

@dvotf

 

It seems that you have resolved it by yourself. If it is working now, you can mark your reply as solution to close this thread. 🙂

 

Best Regards,

Herbert

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors