Forum Discussion
Help with Creating a Simple Chart
In the query editor, select the order, region, and state columns the go to transform > unpivot > unpivot other columns:
Then select the Value column and remove blanks, leave only the X's
Rename Attribute to Fruit and click close and apply.
Then you can add the fruit column to the axis and a simple measure to count the rows of the table to get your count by fruit.
I have attached my sample .pbix for you to look at.
Worked beautifully in Import mode. Thank you!
Out of curiosity, is there a similar function if using Live Connection to a SSAS tabular cube?
You don't have the transform options when connecting to a SSAS model but you could transform the data before feeding it into SSAS using a UNION in a SQL view that would replicate the unpivot.
I'll give UNION a try. At least now I have a back-up plan if that doesn't work out.
Thank you again. Appreciated.