Any way to use Calculated Measures in Visual Axis

[sb_powerbi]

Hello,

Please help me with your suggestion to fix my issues, As per the earliers questions posted , I not able to use measure in Visual axis.

I have already tried below methods.

1. Try to create separate calculated table- direct Query mode not supporting to create calculated table.

2. Tried creating calcialted column using measure- Not supported by direct query mode.

I have created measure wch contains the growth  values and salary details. I have to create one visual to display range like (0%,5%,10%..) .and salary in Y axis .

Please suggest me on the possibilities to cover the requirement.

[Greg_Deckler]

Probably not going to be able to get there with Direct Query mode. Generally, this requires the "disconnected table trick" which you probably can't create because of Direct Query. The disconnected table goes in the axis. And then a measure for each item in the axis along with a final measure (the one you put in the Values) with a HASONEFILTER and SWITCH statement.

[sb_powerbi]

Thanks for the Suggestion. Absoultely your right.

HASON doesnt support in direct query mode.