Forum Discussion
Field parameters with normal slicers
Yes, I am aware that this solution might not work for table/matrix.
Only two possible workarounds that I can think of are:
create a switch measure which will dynamically pick the measure based on the condition and implement either of two options
1. Place a text box on top of the measure field in the table visual and for the text box you can give a dynamic measure name as a value.
2. Complete remove the meausre name from the visual and give a dyanamic title to your table visual.
I accepted your connection request on linkedin
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Super Userssomtom
create a disconnected table with meausre names.
Add this column as a slicer in your report page. Then modify all three measures with a conditional clause like this
Measure A =
IF( SELECTEDVALUE('Measures Mapping Table'[Key]) = "A",
10 )
Measure B = IF(SELECTEDVALUE('Measures Mapping Table'[Key]) ="B" , 20)
Measure C = IF( COUNTROWS(VALUES('Measures Mapping Table'[Key])) = 2 || NOT(ISFILTERED('Measures Mapping Table'[Key])) , 30 )
-- replace, 10, 20 and 30 in the above measures with your actual measure definition. And that its.
when you selecte
first measures:
Second measure
Both Meausres:
None selected
I am attaching the PBIX
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Hi, first of all, your solution is amazing for me with beutiful logic.
It's almost perfect for me. I need just a little fixing yet. I would like to use this measure combination with some dimension data, but if I change the visual type to table in your example file, the empty measures got field name with blank result. E.g in this picture I would like to see just Measure C field.
Thank you. (I've connected to you in Linkedin)- tharunkumarRTK
Yes, I am aware that this solution might not work for table/matrix.
Only two possible workarounds that I can think of are:
create a switch measure which will dynamically pick the measure based on the condition and implement either of two options
1. Place a text box on top of the measure field in the table visual and for the text box you can give a dynamic measure name as a value.
2. Complete remove the meausre name from the visual and give a dyanamic title to your table visual.
I accepted your connection request on linkedin
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
