Help using column data for comparison charting

[dvotf]

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.

[dvotf · Accepted solution]

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).

[v-haibl-msft]

@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