Passing clicked measure to parameter

[bantoszewski]

Hi,

I have a matrix with two measures:

I would like to show dynamically on a chart either mSales or mVoume depending on the measure clicked.

I know how to do it by using a field parameter with these two measures but how can it be done dynamically so that the parameter reads which measure was clicked? Something like selectedvalue?

[uzuntasgokberk]

Hello @bantoszewski,

As far as I know, there is no dynamic in field parameter. İf you would like to see more measure in your slicer. You need to add in your DAX code. Right now there is no UI for field parameter which you added before(İf you create a new parameter ofc, there is an UI).

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[bantoszewski]

I'm sorry uzuntasgokberk but I don't fully understand Your answer besides that it seems the field parameter isn't the way to go.

It doesn't have to be a parameter. Do you think there is any other option to show dynamically on graph one of two clicked measures (column)? Of course it can be DAX but if you could please guide me a little bit (I am a beginner).

[uzuntasgokberk]

Hello @bantoszewski,

When you click measure or column, you would like to see as changed the visualization automatically. Field parameters is doing well. Also there is other options too I shared one of the Power BI dynamic measure youtube link: "https://www.youtube.com/watch?v=ZWd1tZ5SJNU"

However, ın the beginning as far as I understand that when you added a new measure in your "Data" section, somehow you would like to see change the visualizaion(graph etc.) automatically without to changes right?

İf I have been misunderstood, could you please give more detail about what you would like to do?

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[bantoszewski]

I'll try to explain more clearly.

1. I have this a table of products with sales and volumes in each months

2. I want to show the graph of either sales or volumes per month.

Normal Power BI behavior is that when a yellow cell is clicked then the graph shows a graph of sales of product A in the corresponding months:

3. When user clicks on product B the graph automatically changes into product B, so it works as I want:

4. However when user clicks on Volume of product A the graph still shows Sales of product A (because I want the graph to show just one measure):

5. This is not what I want. I would like it to look:

So if user clicks "340" the graph would show mSales measure of product A and when user clicks "105" the graph would show mVolume measure of product B. It would be most intuitive and user friendly in my opinion.

6. Now I can achieve it only by introducing the Parameter slicer which is one more click to be done and makes the whole interactivity "less interactive".

Thank you so far for your help 🙂

[Anonymous]

Hi @bantoszewski ,
According to your description, in power bi's matrix, when you select a number in VALUE, it automatically locates to the previous level. This is caused for the correlation of the data. That is, it is set up for drilling down. In addition to using filed parameter for this as mentioned above, you can also use both line graphs at the same time.

Best regards,
Albert He

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

[bantoszewski]

OK, I'll ask differently.

Is there any option for DAX to know which measure has been clicked? And then be able to refer to it?

For exampe if user clicks on:

DAX should store information: "mSales" has been clicked".

When user clicks on:

DAX should store information: "mVolume" has been clicked".

Is it stored anywhere? If it was I could for example create a measure "chosen_measure", make a graph visualisation with it and it would present either "mSales" or "mVolume".

I am wondering because it looks for me as a really simple feature. I could imagine that in different programming languages it would be sometinh like "selected_value", "clicked_object", in VBA you could even assign code for mouse over button, or clicked behaviors.

Each line for each measure makes the graph hard to read when you want to show lets say 5 or 10 different measures.

I tried to use calculated items with selectedmeasure with tabular editor but I can't find a solution.