Dynamic Measure

[Anonymous]

Hi Community..!

I have measure called as HCPs Reached, HCPs Engaged, Calls and Call Attainement

The requirement here is like this : I am going to use Line chart and i want to change x-axis and y-axis dynamically.

Above all measures i should select to the x-axis or y-axis vise varsa.

The user want to compare one measure to another measure 

Eg: User can select HCPs Reached at x-axis and HCPs Engaged at Y-axis or vise varsa.

also User can select Calls at x-axis and Call Attainment at Y-axis or vise varsa.

Does this possible?

Can we pull measures to the x-axis?

I was tryiing but did not work using Field Parameter.

[Anonymous]

Hi @Idrissshatila 
Could you please create in pbix file send it to me?
Because i have tried and did not work.

Thanks in advance..!

[Idrissshatila]

Hello @Anonymous ,

you're right it doesn't work to add a measure to x axis in the column chart, so if you want to compare two measures you can use the Stacked bar chart as the following

[Kedar_Pande]

@Anonymous 

If field parameter doesnt meet your requiement,

1. Create a Calculation Group:
2. Add calculation items for HCPs Reached, HCPs Engaged, Calls, and Call Attainment.
3. Add the calculation group to the X-axis or Y-axis of the chart. Users can select measures via slicers bound to the calculation group.

💌 If this helped, a Kudos 👍 or Solution mark ✔️ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[Idrissshatila]

Hello @Anonymous ,

why it didn't work with field parameter, create 2 field parameters haveing both the same measures and assign each paramters to an axis, this would work like this.

try it and let me know.