Forum Discussion
Dashboard Card change
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,
3 Replies
- amitchandak
Super User
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/
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-xiaotangCommunity Support
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.
