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.
Hi-Power BI geeks,
I am trying to bring text display into the card visual and it should display when two slicers and one clustered bar chart visuals are filtered.
So I tried to use the below Dax measure.
Solved! Go to Solution.
I am in a similar boat, I am using the code. Current Sku/Description =
IF (
ISFILTERED ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
FIRSTNONBLANK (
TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description],
TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description]
),
""
)
This creates a measure that shows on a card only the selected filter.
But what I need help with is having the card show multiple filter selections. Instead of just the first non-blank filter selection.
Is the value displayed that if the selected value in the filter? If so, so can try something along the lines of:
Filter Values =
IF (
ISFILTERED ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
CONCATENATEX (
VALUES ( TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description] ),
TRPT_FS_COPA_ADHOC_DTL_V2[SKU/Material Description],
", "
),
""
)
Proud to be a Super User!
Paul on Linkedin.
Create a measure to use for to format the value conditionally. Something along the lines of:
Format Card Value =
IF(
ISFILTERED(PainPoint[Ref_SprintTopics]) || ISFILTERED(PainPoint[Initiative Ref]) || ISFILTERED(PainPoint[Raised By]), 1, 2)
Here is an example using an equivalent measure and formatting the value conditionally:
Proud to be a Super User!
Paul on Linkedin.
Hi Paul, thanks for looking into the query.
But, my measure display just 1 and 2, so when I select a visual it should show a text from one of my tables columns. Below is how it should show.
But when I unselect all visuals it is showing as below, and how I don't want.
Regards
Raj
The card visual must have the measure you need. The Measure for the conditional format you use in the conditional format for the card visual as shown in the screenshots I posted (you will need to adjust the colours of course)
Proud to be a Super User!
Paul on Linkedin.
Thanks, Paul, it worked:)
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |