The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a requirement where I have to display the total number of opportunities and the total number of opportunities won for an individual client.
I have created two measures for total opportunities and the opportunities won but I want to display the output via a click.
For eg,
When I click on the 'Total Opportunities' button, the value of total opportunities for that client should display and
When i click on 'Opportunities Won' the value of opportunities won should display.
Any suggestions on how I can achieve this?
Solved! Go to Solution.
Hi,
You can use fields parameter to archive that behavior.
Take a look at this example:
Proud to be a Super User!
Hi @Pragadeesh
You can create field parameter using measure.
steps1:got to moedling tab > add parameter > click on filed option
step2: drag and drop your 2 measures from right side to left side
Step3: click on create > slicer is added on your page
step4: take your parameter value in your card visual/ on your chart axis / on your table value.
As you can see by clicking on different option in slicer it changes values.
I hope I answered your question!
Hi @Pragadeesh
You can create field parameter using measure.
steps1:got to moedling tab > add parameter > click on filed option
step2: drag and drop your 2 measures from right side to left side
Step3: click on create > slicer is added on your page
step4: take your parameter value in your card visual/ on your chart axis / on your table value.
As you can see by clicking on different option in slicer it changes values.
I hope I answered your question!
Hi,
You can use fields parameter to archive that behavior.
Take a look at this example:
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |