Changing the Axis dynamically (values versus % contribution)

[Walt1010]

Hi all,

I have a column chart in which I graph values on the Y axis against binned values in the x axis. the values being the actual value, or the percentage contribution, depending on which option I've selected. I've displayed the 2 options, below, as 2 separate charts. My question is, how can I display the axis choice as a parameter option, and allow users to select it themselves? I thought I could do it via field parameters, but it doesn't seem obvious. Please help !

[vanessafvg · Accepted solution]

For field parameters you need to create an explicit measure, what you have on here is the implicit measure, so you need to actually write a measure for each option and then you can put them into field parameters.  make sense?

[brsamyrmoises]

Hey Walt!

I would recomend you to check this Guy in a Cube video here : 3+ approaches for Dynamic Axis in Power BI - YouTube
There are simple ways to solve your need, If this video does not address your need, let me know that we can show you some simple path to solve it!

Take care!

[vanessafvg · Accepted solution]

For field parameters you need to create an explicit measure, what you have on here is the implicit measure, so you need to actually write a measure for each option and then you can put them into field parameters.  make sense?

[Walt1010 · Accepted solution]

It does make sense. I'll do that, thanks!