DAX measure in x axis help needed

[stevedata]

Hi all

I have 4 measures (product1, product2, product3, product4) that I want to have in a chart.

I am trying to show a chart with the measures in the x axis.

Currently I can get to the first screenshot below, with each bar representing a product %. But I want to achieve vice versa – i.e. each bar representing region % and each grouping representing product.

Each measure looks like this:

Product1 =

SWITCH(TRUE(),

    SELECTEDVALUE(AllRegions[Region]) = "GLOBAL"

    , CALCULATE('#Product1'[#Product1responded%], ALL(AllRegions[Region]))

    , '#Product1'[#Product1responded%])

I want to get to this:

Can anyone help?

[Anonymous · Accepted solution]

Hi @stevedata ,

First of all, many thanks to  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the multiple measures for the product.

Product 1 = 
VAR produc_1 =  CALCULATE(SUM('Table'[Sales]), FILTER('Table', 'Table'[Product ID] = 1))
var tota_ = SUM('Table'[Sales])
RETURN
DIVIDE(produc_1, tota_)

3.Create the new table for the product measure.

4.Create the new measure to display product percentage.

Product group = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Product'[Product]) = "Product 1", [Product 1],
    SELECTEDVALUE('Product'[Product]) = "Product 2", [Product 2],
    SELECTEDVALUE('Product'[Product]) = "Product 3", [Product 3],
    SELECTEDVALUE('Product'[Product]) = "Product 4", [Product 4]
)

5.Select the Percentage Format for the new measure.

6.Drag the measure into the Y-axis and drag the Region into the Legend.

7.The result is shown below.

Best Regards,

Wisdom Wu

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

[Ritaf1983]

Hi @stevedata 
Please refer to my solution in the linked discussion.

https://community.fabric.microsoft.com/t5/Desktop/Spacing-between-bars-for-clustered-column-chart-th...

It includes a pbix with an example.

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