Forum Discussion
Passing clicked measure to parameter
Super UserHello 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 |
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 |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 🙂
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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly