Dashboard Card change

[Anonymous]

I have 2 cards in the dashboard.

1. Monthly Hours

2. Weekly Hours

I have 2 slicers one containing months Jan to Dec and the other slicer is weeks like 1st-week 2nd week, etc.

When I select march from slicer both the card shows monthly hours I want only the monthly card to show monthly hours

and when I select month with week and the other card should work 

until any slicer is selected I don't want card to show anything instead show "Please select the option"

Thanks,

[Anonymous]

Thanks but something else worked for me

if (selectedValue("tablename"[column])=1,"sum("tablename"[column])",

if (selectedValue("tablename"[column])=2,"sum("tablename"[column])",

if (selectedValue("tablename"[column])=3,"sum("tablename"[column])",

if (selectedValue("tablename"[column])=4,"sum("tablename"[column])","Please select value")

but had to write it for each value 

[v-xiaotang]

Hi @Anonymous 

usually information below is needed, could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result and its math formula based on the sample you provide.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@Anonymous , You can use isfiltered and hasonevalue to check and show measure or return a blank

if(isfiltered(Table[Month]), [Measure], blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/