Forum Discussion

mukul_jain's avatar
mukul_jain
Frequent Visitor
6 years ago
Solved

current month dates in Date Slicer

Hi All,   I have a date slicer in my report and the filter for this visual is set to relative date 'is in this - Month'. When I initially published the report, it was working and it showed the date...
Need Help
  • mukul_jain's avatar
    mukul_jain
    6 years ago

    Hi Icey ,

    Unfortunately, this is not working for me even with the desktop service. 

     

    Seems like a glitch in this particular file. I created a new file from scratch and replicated the steps, but the issue is not re-occurring. 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi mukul_jain ,

I have tested on Power BI Desktop, and it works well. I can't test it in Power BI Service. Maybe you could try it again.

 

 

Or, you can create a new table like below and create relationship among your tables. And use this column as a date slicer.

Table 2 = 
CALENDAR (
    DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ),
    EOMONTH ( TODAY (), 0 )
)

 

 

Best Regards,

Icey

 

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

mukul_jain's avatar
mukul_jain
Frequent Visitor
6 years ago

Hi Icey ,

Unfortunately, this is not working for me even with the desktop service. 

 

Seems like a glitch in this particular file. I created a new file from scratch and replicated the steps, but the issue is not re-occurring. 

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi mukul_jain ,

    Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

     

    Best Regards,

    Icey