Sample Data - how did you hear about us.xlsx (471.5 KB)
Hi
I need help with the attached dataset. I want to show the result of the attached survey and provide the % and count for each category. Unfortunately, it doesn’t give me the correct figure, I think it’s because the table also count the blanks? What is the best and easiest way to visualise this on a bar chart?
Thanks
Yes, this is the output I need. But is there a way to show the same without unpivoting the columns in the query editor? Can we calculate and show the same output through DAX formula?
This the best and easiest way.
If I unpivot, will it have an effect on the existing visuals and do I have to fix the calculations? I do have existing visuals and I am afraid that the result would change if I unpivot. Can you please advise/clarify?
Bumping this post for more visibility.
We don’t know how you created existing visuals. Yes, It will effect existing visuals.
Can’t you create existing visuals with unpivot data ?
If you don’t want to break your existing visuals, you’ve to create another table using DAX(unpivot).
As always, @Rajesh is spot on in his response. However, the DAX unpivot pattern is pretty cumbersome. I prefer to reference the table I want to unpivot in PQ (for example Sales), unpivot the table created and rename it (e.g. Sales Unpivoted), join it to my data model and work off the original or unpivoted version as needed.
Hello @BM_Girlracer, it’s been a while since we got a response from you.
Just following up if you still need help with your inquiry?
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @BM_Girlracer, due to inactivity, we’ll be marking this post as solved.
