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

[Nazdac911]

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 

[Anonymous]

look at your data. are there errors or blanks?

[Nazdac911]

I have blanks , but no errors 

[v-yueyunzh-msft]

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

[Nazdac911]

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 

[v-yueyunzh-msft · Accepted solution]

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

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