How can show Current Week data value in dashboard without selecting week slicer

Question

Hi All,&nbsp; &nbsp;&nbsp;I need a help to create dashboard for current week data. I want to show current week sales value,target,SPLY ,MTD in card &amp; visuals on dashboard without any week no. slicer. Is this possible to show value.&nbsp;Thanks,Varsri&nbsp;&nbsp; &nbsp; &nbsp;

speedramps · Answer

Hi Varsi&nbsp;Try this ...https://community.powerbi.com/t5/Desktop/Display-this-week-amp-this-month-data/td-p/11101&nbsp;

v-deddai1-msft · Answer

Hi Anonymous&nbsp;,&nbsp;You can filter your data in dax formula:WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )Best Regards,Dedmon Dai

anonymous · Answer

Hi Speedramps,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thanks for sharing this valuable link.&nbsp;Thanks,Varsri

anonymous · Answer

Hi&nbsp;Dedmon Dai,&nbsp;&nbsp; &nbsp; &nbsp;Thanks fo giving your valuable time..This dax is sworking.&nbsp;Thanks,Varsri

Forum Discussion

How can show Current Week data value in dashboard without selecting week slicer

4 Replies

Related content

Dyanamic Dashboard based on Excel Selection

Dashboard Access

PowerBI Dashboard Templates or Sample Dashboards

Dashboard

Selected slicer