DAX and Filters

[brunakopik]

Hello,

I am trying to use filters for 3 fiscal years, as well as a "Select All" option, so that I can see all fiscal years together (see attached image). Is there a DAX I can use to display text ONLY for 2023/24 (and nothing show up when I click on other slicers)? This is what I have so far, but instead of showing "Not created" when I click on 2023/24, it appears when I click on "Select All":

ERGS =

IF(

    ISFILTERED('Fiscal Year'[Fiscal Year]),

    SELECTEDVALUE('Fiscal Year'[Fiscal Year], "No Fiscal Year Selected"),

    "Not created"

)

Thanks!

[Anonymous · Accepted solution]

Hi @brunakopik ,

If you want to display it this way in a bar chart, then as Selva-Salimi  mentioned in a previous reply, the bar chart accepts numbers. Therefore, you can use the method of displaying the card that Selva-Salimi  mentioned earlier and modify the expression.

card_MeasureLD =
IF (
    SELECTEDVALUE ( 'Fiscal Year'[Fiscal Year] ) = "2024/25"
        || SELECTEDVALUE ( 'Fiscal Year'[Fiscal Year] ) = "2025/26",
    "To be determined",
    BLANK ()
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Selva-Salimi]

Hi @brunakopik 

you can do as follows:

first, create a measure:

  card_Measure = if (SELECTEDVALUE('Fiscal Year'[Fiscal Year]) = "2023/24" , "Not Created", blank())

then, use a card visual and add this measure in card fields. go to card visual setting, and define a conditional formatting

the condition should be as follows:

move this card on your column chart and set it to "send to back"

*using this trick can fulfill your expectations!

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

[brunakopik]

Hello,

Thank you so much, this is really helpful!! It works!

Is there a way I can have a "not created show up when they are all selected? Like beside the first bar column:

Thanks!

Bruna

[Selva-Salimi]

@brunakopik 

as "not created" is a text and others are numbers and column chart accept numbers so it would not be possible. you just can show "0" by adding +0 at the end of your measure and if the calculation is not measure based, and is column based, then easily write it in a measure (sum(your_column) +0 ).

[brunakopik]

Thank you so much, I appreaciate it!

What if I wanted to be blank when I click on 2023/24, and say "to be determined" for 2024/25 and 2025/26?

I tried this, but it doesn't work:

card_MeasureLD = if(

    OR(SELECTEDVALUE('Fiscal Year'[Fiscal Year]) = "2024/25,

    "2025/26","To be determined")),

    blank()

    )

[Anonymous · Accepted solution]

Hi @brunakopik ,

If you want to display it this way in a bar chart, then as Selva-Salimi  mentioned in a previous reply, the bar chart accepts numbers. Therefore, you can use the method of displaying the card that Selva-Salimi  mentioned earlier and modify the expression.

card_MeasureLD =
IF (
    SELECTEDVALUE ( 'Fiscal Year'[Fiscal Year] ) = "2024/25"
        || SELECTEDVALUE ( 'Fiscal Year'[Fiscal Year] ) = "2025/26",
    "To be determined",
    BLANK ()
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[brunakopik · Accepted solution]

Thank you so much! This works great.

Bruna