How to use multiple measures in single X/Y axis in chart

[AshP]

Hi all,

I have created multiple measures to sum up sales for different days like D1,D2,D3 etc for different stores

Now I need to create a line or bar chart with them but they should all be in x-axis. Like if I can create a group and put it in x.axis

Something like this :

I tried creating a calculated group and using it in x-axis, but not working as expected. Can you help me with this ?

[Anonymous · Accepted solution]

Hi @AshP ,

In powerbi destkop, the y-axis in the clustered column chart supports multiple measure values. Just like below:

m_a =
CALCULATE (
    SUM ( YourTable[Sales] ),
    FILTER ( YourTable, YourTable[Store] = "A" )
)

m_b =
CALCULATE (
    SUM ( YourTable[Sales] ),
    FILTER ( YourTable, YourTable[Store] = "B" )
)

Best Regards,
Adamk Kong

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

[Anonymous]

Hi @AshP ,

You can achieve a similar effect with dynamic measure values. Refer to the following example:

D1 Sales = SUMX(FILTER('YourTable', 'YourTable'[Day] = "D1"), 'YourTable'[Sales])

D2 Sales = SUMX(FILTER('YourTable', 'YourTable'[Day] = "D2"), 'YourTable'[Sales])

D3 Sales = SUMX(FILTER('YourTable', 'YourTable'[Day] = "D3"), 'YourTable'[Sales])

result = SWITCH (
   SELECTEDVALUE('NewTable'[Day]),
   "D1", [D1 Sales],
   "D2", [D2 Sales],
   "D3", [D3 Sales],
   BLANK()
)

Best Regards,
Adamk Kong

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

[AshP]

Hi Adamk, Thank you for your reply, But I can't use measures in the slicers as the customer requested to have all the days sales(D1,D2,D3 etc in one visual for different stores so that they can compare at a time.  

Some thing like above. Can we put all the measures in a column and use it in X or Y axis ? Is there anyway to achieve this ? 

Thank you