Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
In your IF statement you have to aggregate the column in some way. If it's text, use IF(FIRSTNONBLANK([slicercolumn], 1) = "A"....etc.
Proud to be a Super User!
In your IF statement you have to aggregate the column in some way. If it's text, use IF(FIRSTNONBLANK([slicercolumn], 1) = "A"....etc.
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |