Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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).
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).
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |