Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Could you please answer the following question: ' how can I create a parameter in order to select a measure?'
In other words, I would like to create a parameter that contains Sales - Profit - Cost and Quantity, so when I select Sales, my dashboard will be showing Sales by X dimension, or when I choose Profit, the dashboard will be showing Profit by X dimensions.
Thank you in advance,
Rita
Solved! Go to Solution.
@Anonymous
You might try:
IF(SELECTEDVALUE(‘Select a measure’[column]= “Nb of users”, [Nb of users by Machines and Trigramme], [your other measure])
(or the appropriate measures)
there cannot be a relationship between your ‘Select a measure’ table and the dataset, and
better to make the slicer “Single Select”
Proud to be a Super User!
Paul on Linkedin.
Hello TijnOnline,
Thank you for your help, but I guess you got me wrong; below is a snapshot of what I'm looking for:
You have a parameter named Select a measure that contains Nb of users, cost sales measures when I click on Nb of users, the charts will show me Nb of users by Machines and Trigramme, without navigating to other dashboards.
Thank you in advance,
Rita
@Anonymous
You might try:
IF(SELECTEDVALUE(‘Select a measure’[column]= “Nb of users”, [Nb of users by Machines and Trigramme], [your other measure])
(or the appropriate measures)
there cannot be a relationship between your ‘Select a measure’ table and the dataset, and
better to make the slicer “Single Select”
Proud to be a Super User!
Paul on Linkedin.
Hello,
Thank you for your Help !!!
Rita
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |