topic DAX and Filters in DAX Commands and Tips

DAX and Filters

Anonymous — Tue, 03 Dec 2024 23:32:19 GMT

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!

Re: DAX and Filters

Selva-Salimi — Wed, 04 Dec 2024 05:48:12 GMT

Hi Anonymous

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.

Re: DAX and Filters

Anonymous — Wed, 04 Dec 2024 17:57:32 GMT

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

Re: DAX and Filters

Selva-Salimi — Thu, 05 Dec 2024 10:04:47 GMT

Anonymous

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 ).

Re: DAX and Filters

Anonymous — Wed, 11 Dec 2024 23:24:43 GMT

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()

)

Re: DAX and Filters

Anonymous — Wed, 18 Dec 2024 01:55:36 GMT

Hi Anonymous ,

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.

Re: DAX and Filters

Anonymous — Mon, 23 Dec 2024 18:52:12 GMT

Thank you so much! This works great.

Bruna