Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ccunningham
Regular Visitor

Dynamic calculate Measure value based on Slicer Selection

Can I make different text appear depending on the slicer? 

 

For example, I select 'A' on the slicer, the text appears saying 'A selected'

 

I was thinking I could make a text measure: TEXTMEASURE = IF([slicercolumn] = "A", "A Selected", "not") , but I cannot reference the column. 

 

I am very new to Power BI. 

1 ACCEPTED SOLUTION
KHorseman
Community Champion
Community Champion

In your IF statement you have to aggregate the column in some way. If it's text, use IF(FIRSTNONBLANK([slicercolumn], 1) = "A"....etc.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
KHorseman
Community Champion
Community Champion

In your IF statement you have to aggregate the column in some way. If it's text, use IF(FIRSTNONBLANK([slicercolumn], 1) = "A"....etc.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.