Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have the below dataset
Column O is a question from a survey that asks customers what word(s) best describe the service they received from us. As there are multiple choices to pick from and a respondent can pick multiple words, it splits the question and answers into a number of columns (O - V).
I need to use a bar graph to show how many times each word has been selected and be able to filter the visual by date. Does anyone have any suggestions/help/tutorial?
Thanks a lot for reading.
James
Solved! Go to Solution.
@Anonymous ,
Click query editor-> Transform-> click on the columns then click "Unpivot columns". You will achieve two columns [Attribute] and [Value]. Then create a measure using dax like pattern below:
Helpful_Count =
CALCULATE (
COUNT ( Table[Value] ),
ALLEXCEPT ( Table, Table[Start Date], Table[Attribute] )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-yuta-msft
I had to add a little bit in so my measure ended up looking like this:
@Anonymous ,
Change date format to yyyy/mm/dd, then create measures using dax like pattern below:
Helpful_Count =
CALCULATE (
COUNT ( Table[Helpful] ),
FILTER ( ALLEXCEPT ( Table, Table[Start Date] ), Table[Helpful] = "Helpful" )
)
The other measures is similar with the one above, you just need to change "Helpful" with other words.
Finally, drag date column to X-axis and measures to value field in the bar chart.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yuta-msft
Thanks for the comment.
I have tried the formula but I don't get the result I was hoping for.
I am aiming to have a visual that looks something like the below and to be able to filter it by month (using a slicer) to show the results for the selected month.
Many thanks
James
@Anonymous ,
Click query editor-> Transform-> click on the columns then click "Unpivot columns". You will achieve two columns [Attribute] and [Value]. Then create a measure using dax like pattern below:
Helpful_Count =
CALCULATE (
COUNT ( Table[Value] ),
ALLEXCEPT ( Table, Table[Start Date], Table[Attribute] )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-yuta-msft
I had to add a little bit in so my measure ended up looking like this:
@Anonymous ,
Could you please share the sample data so that I could do further analysis?
Regards,
Jimmy Tao
Hi Jimmy
Please see the link below
Many thanks
James
User | Count |
---|---|
99 | |
90 | |
83 | |
72 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |