Forum Discussion

RJ_KON's avatar
RJ_KON
Icon for Helper I rankHelper I
4 years ago
Solved

DAX measure using isfiltered function

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...
Tips and Tricks
  • RJ_KON's avatar
    RJ_KON
    4 years ago

    Thanks, Paul, it worked:)

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

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:

RJ_KON's avatar
RJ_KON
Icon for Helper I rankHelper I
4 years ago

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

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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)

    • RJ_KON's avatar
      RJ_KON
      Icon for Helper I rankHelper I
      4 years ago

      Thanks, Paul, it worked:)