Forum Discussion

wynhodgkiss's avatar
wynhodgkiss
Advocate II
3 years ago
Solved

Measure Names Dimension

Hi,

Anyone that has used Tableau will understand the concepts of Measure Names as a Dimension and Measure Values as a Measure, making it much easier to present multiple measures in either tabular or visual form. My question is whether there is a way to create the same thing in Power BI.

In my example I have 6 measure for the same product that could be presented in a single line chart (with 6 meaures on the y axis) but I'd like to see them as small multiples.

1: Is there any way of creating a field that can be used as my dimension by which to split the single chart into small multiples?

2: Bonus points if it can be turned into a function to use in future reports with any necessary tweaks

 

PS. I know that I can create a new table with all 6 measures in 1 column, I am just hoping there is a more elegant, quicker way of achieving the same.

2 Replies