Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a some string text I would like to include on top of a chart showing sales when certain a first slicer is selected. This first variable is "company". I managed to do this with a card and calculated column, however, I need the text to disappear when other filters are selected (e.g. "service type" and "region".). All slicers are columns and I'm not sure how to activate one and deactivate the others.
Thank you.
Solved! Go to Solution.
Hi @Elisa_E,
Could you try using the formula below to create a measure, then just show the measure on the Card visual(no need to apply it as visual level filter) to see if it work in your scenario?
Measure = IF ( HASONEVALUE ( Table1[Region] ) || HASONEVALUE ( Table1[Service Type] ), "", IF ( HASONEVALUE ( Table1[Company] ), FIRSTNONBLANK ( Table1[Dynamic text], 1 ), "" ) )
Remark: You'll need to replace Table1 with your real table name.
Here is the sample pbix file for your reference.
Regards
Hi @Elisa_E,
Based on my test, the formula below should work in your scenario.
Measure = IF ( HASONEVALUE ( 'region'[region] ), FIRSTNONBLANK ( region[region], 1 ), IF ( HASONEVALUE ( 'service type'[service type] ), FIRSTNONBLANK ( 'service type'[service type], 1 ), IF ( HASONEVALUE ( 'company'[company] ), FIRSTNONBLANK ( 'company'['company'], 1 ) ) ) )
Remark: You'll need to replace the bold with your real table name and column name.
Regards
Hi @v-ljerr-msft,
Thanks for this! I tried this measure as a visual filter, (show items if = 1), but then the visual then won't show at all, so I'm likely doing something wrong.
What I am trying to do is show text (from the dynamic text column below) only when Company A or B is selected in a slicer. I've managed this with a card. However, I need this text to disappear when a specific region or service type is selected. Not sure if this is possible.
Thanks again.
Hi @Elisa_E,
Could you try using the formula below to create a measure, then just show the measure on the Card visual(no need to apply it as visual level filter) to see if it work in your scenario?
Measure = IF ( HASONEVALUE ( Table1[Region] ) || HASONEVALUE ( Table1[Service Type] ), "", IF ( HASONEVALUE ( Table1[Company] ), FIRSTNONBLANK ( Table1[Dynamic text], 1 ), "" ) )
Remark: You'll need to replace Table1 with your real table name.
Here is the sample pbix file for your reference.
Regards
This works perfectly! Thank you so much!
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |