Showing calculated masure name in bar chart axis

[BigKev]

Hi All,

How can I display the ‘Calculated Measures’ Name in the Y Axis?

Essentially, TEST_1 to TEST_4 are calculated measures.
When I plotted in the bar chart, for some reason there are no options to display the calculated memasures name, unless if I enable Legend.

This is what I want to achieve

Please Help.

Cheers,

Kev

This is what I want to achieve

[Anonymous]

Hi @BigKev 

The Power bi doesn't support this feature now.

Maybe you can consider the qqqqqwwwweeerrr's workaround, or you can submit an idea on Microsoft Fabric Ideas:

Home (microsoft.com)

Best Regards

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

[qqqqqwwwweeerrr · Accepted solution]

Hi @BigKev 

This is a workaround that i have tried. 

you need to create new table like below

MeasureNames =

DATATABLE(

    "MeasureName", STRING,

    "MeasureType", STRING,

    {

        {"Sum of Sales", "Sum"},

        {"Average of Sales", "Average"}

    }

)

for you it will be test 1 to test4 

and then create a measure 

Selected Measure =

SWITCH(

    SELECTEDVALUE(MeasureNames[MeasureType]),

    "Sum", [Amount],

    "Average", [average],

    BLANK()

)

and this what final output look like 

on left if you see i have two measure sum of sale and average of sales but in right chart i have used measure in y-axis and Measure name in x-axis  see below

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards