topic Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual in DAX Commands and Tips

Nothing selected in Power BI Slicer? Then don't show data for Card visual

Nazdac911 — Fri, 16 Dec 2022 08:16:30 GMT

Hi all

Their are many videos explaing how to apply this but Cards visuals and also Funeel visuals are not axcepting them !!!???

to ellaborate more :
i have slicer for product and I build a measure like this :

and then I want to apply this measure as filter input for a Card visual :

But when I add the measure here , it will not work !!!

Could any boday exaplain why and how could I solve this ?

Thanks in advance

Regards

Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual

Anonymous — Thu, 15 Dec 2022 09:48:55 GMT

look at your data. are there errors or blanks?

Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual

Nazdac911 — Thu, 15 Dec 2022 10:46:40 GMT

I have blanks , but no errors

Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual

v-yueyunzh-msft — Fri, 16 Dec 2022 02:09:28 GMT

Hi , Nazdac911

Do you mean when you put a field or the measure on the card visual and it shows BLANK() and you have not filter in the visual.Right?
First, you need to check the fields you placed on the card or when the measure is returned, where the measure is calculated by default based on the current filter context.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual

Nazdac911 — Fri, 16 Dec 2022 08:18:41 GMT

Hi v-yueyunzh-msft

thank you for yor reply , I just added some more ellboration to my question 🙂

Thanks a gain and looking forward for yuor help

Regards

Re: Nothing selected in Power BI Slicer? Then don't show data for Card visual

v-yueyunzh-msft — Fri, 16 Dec 2022 09:09:32 GMT

Hi, Nazdac911

According to your detailed problem description, I have done some local tests here, and I found that if you use measures to be placed in the visual filter of the card graph, the visual filter cannot take effect and the value is selected, and the reason for this limitation is because the card chart is originally used to display the value after an aggregation operation, and the measure value is also used to display the value after the aggregation operation, and when you put the measure as a filter for the value after the aggregation operation, is not supported. If you want the card chart to display the corresponding values based on your slicer filter, you need to place your measure in the card chart and return the value you want according to the different judgments of the measure.　For example:

IF(ISFILTERED([Column1]),"data when is filtered","data when is not filtered")

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly