Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Controlling Visual's default Content

HI Experts,   I have a scenario in which there is a page with 1 line chart with slicer fitlered for last 3 weeks and two  bar chart visuals.   When the report is opening for first time except the...
Tips and Tricks
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

Please try the following formula:

 

 

measure = 
IF ( 
    HASONEVALUE ( Table1[TIMEDATE] ),
    DISTINCTCOUNT ( Table1[Empnumber] ),
    CALCULATE (
        DISTINCTCOUNT ( Table1[Empnumber] ), 
        FILTER ( 
            Table1, 
            Date ( Year ( Table1[TIMEDATE] ), Month ( Table1[TIMEDATE] ), Day ( Table1[TIMEDATE] ) ) = Today () 
        )
    )
)

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Winniz,

 

Thank you so much for taking time to respond my issue.

Due to deadlines, I was forced to apply a workaround with set of butttons (Today/Other days), bookmarks I was able to show the data correspondingly.

 

Anyway, I tried applying the formula you have provided,  bar chart at the right showed the current date value initially but it displayed nothing when any of the data point is selected in the line chart. Thanks Anyway.