Put measurements as axes of a graph and axes in legend

[Syndicate_Admin]

Hello

I'm trying to represent a graph I had in Google Sheeds in Power BI, but I can't figure out how to do it.

The graph I want to obtain is:

In my power BI model:

CT, CM and Total are values of a category.

Fact. 2019, Fact. 2020, Fact. 2021, Pdos. Entered 2019, etc. are measurements.

In power BI, I get:

But I would like CM and CT to be legendary and measurements to appear as an axis. The problem is, when I put CM and CT in legend, it only allows me to put a measurement in the value field.

In google sheets there is the option of "Switch rows / colums" that allows me to make this change in a very simple way:

Did you have any way to do this in Power BI?

[v-xiaotang]

Hi @Syndicate_Admin 

What's your data structure in Data View? If  you want to put measure into Axis, you can refer to this blog,

https://community.powerbi.com/t5/Community-Blog/The-workaround-of-using-the-measure-as-axis-in-the-v...

Personally speaking, this method is the most recommended.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Syndicate_Admin , You might have to unpivot the tables

example like

https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905

Or create a custom table

union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)

or

union(
summarize('Table',"Measure parent","Measure1","Measure",[Measure1])
summarize('Table',"Measure parent","Measure2","Measure",[Meausre2])
)

or

https://www.daxpatterns.com/dynamic-segmentation/

https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

[Syndicate_Admin]

Hello, thanks for the information, but I think I have not explained myself well.

CT and CM are a category of customers, but that is already defined in the tables, they do not depend on the sales value obtained, they are independent. For example, CT can contain clients: 1, 2, and 3. CM: 4, 5 and 6. And this does not change, therefore, I do not need a dynamic segmentation.

Then, I have Fact. 2019, Fact. 2020, Fact. 2021, Ped. 2019, Ped. 2020 and Ped. 2021 which are measurements made with DAX, are not fields of a table, therefore, I can not make joins between tables.

I will show an example of what I want to do, but instead of using a graph I do it in a matrix. Initially we have:

But we want to have the measurements in the rows and the customer categories in the columns. For this case power BI has a functionality that allows you to do it (endro of values --> show in rows):

I want to do exactly the same thing, but in a graph:

Initially I have (I would need to add the total):

I want (orange is the total):

The "values" option --> "show in rows" is only available in the matrix display and not in the bar graph, therefore, I cannot do it by this method. I was told that there is the possibility of making a measurement with a switch (I have to test it) but I would be interested to know if there are other options.