Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI users
I was wondering if someone can help me with a visualisation problem. I'm trying to visualise some survey questions and the structure of these questions are quite simple in that they are a 5 point likert type question which I'll visualise in a column chart. The complication comes in that associated with the survey questions is also a question asking what area or location each respondent is from. My Business Analyst would like to see in a single column chart total respondent answers for an individual question against a answers to that same question whilst filtered by a specific area. See attached image, I've created two column charts for total response values for question 1 along with total response values for question 1 filtered by Area 2. They would like to see both of them in the same column chart side by side. What method could I use to do this?
Any help would be greatly appreciated.
Kind regards
Mike
Solved! Go to Solution.
Hi,
My reccomendation would be to either create a measure for both, and then display them as values.
m_Total = COUNT(Q1_Answer)
m_Area2 = Calculate(Count(Q1_Answer),Filter(All(Q1_Table),'Q1_Table'[Area] = "Area 2"))
Alternatively you could create a seperate table which is what I had to do with a recent questionnaire based project of mine... but that's a bit tricky so hopefully this works.
Kind Regards,
Ian
Hi,
My reccomendation would be to either create a measure for both, and then display them as values.
m_Total = COUNT(Q1_Answer)
m_Area2 = Calculate(Count(Q1_Answer),Filter(All(Q1_Table),'Q1_Table'[Area] = "Area 2"))
Alternatively you could create a seperate table which is what I had to do with a recent questionnaire based project of mine... but that's a bit tricky so hopefully this works.
Kind Regards,
Ian
Hi @Mike282,
Maybe you could add [Area] field to chart X-axis to create a drill down report. Alternatively, you should create measures to get results of "Question1 filter by Area 2" and "Question1 filter by Area 1", then add measures to the fisrt chart.
Regards,
Yuliana Gu
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |