Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Stefancy
Frequent Visitor

Slicer Check Enabled Date Range not Disabling in Published Report, causing report to close

Community Question – Custom Date Range Stopped Disabling When YTD/PTD Selected

 

Hello – I have a model that uses PTD/YTD/Custom buttons to define the date selection. 

 

These resources describe a lot of the functionality that I employed to disable the custom date range selector if another predefined date range is chosen:

 

https://community.powerbi.com/t5/Desktop/Table-Visualisations-blank-until-something-selected-in-a-sl...

8:37 begins the description:  https://www.youtube.com/watch?v=fKygF7VEJnQ

 

Recently, within the past month or so, the custom date range slicer started being enabled all the time in the published version of the report with the value “0” filled in:

Stefancy_0-1634067511362.png

 

The default view for this report is “YTD” since moving from “Custom” to any other selection causes a problem, outlined here:

https://community.powerbi.com/t5/Desktop/PTD-YTD-still-includes-custom-date-range/m-p/1962595#M74431...

 

Because the custom date range is programmed not to work when anything but “Custom” is selected, if a user enters any date that is less than or equal to today, it locks up and closes:

 

Stefancy_1-1634067511366.png

 

Upon clicking “11,” I am returned to the home screen:

Stefancy_2-1634067511368.png

 

 

The embedded report throws a disconnect error (as expected since the report stops working):

Stefancy_3-1634067511368.png

 

 

 

Was there something in the latest update push that would cause this?  It only happens in the published version. Desktop version becomes disabled as intended:

 

Stefancy_4-1634067511368.png

 

 

Here is a pbix that uses dummy data that I had created in order to post and research the problem that I noted above.  It has a lot of trial an error in it, but the underlying issue is present with this model.  I just published it to a personal workspace and tested it with the same results.

 

https://drive.google.com/file/d/1OqQs0VeLeF-oY4dvDQauZbJaBgHX10qF/view?usp=sharing

 

 

3 REPLIES 3
Stefancy
Frequent Visitor

I found another example of the published report showing differently than the Desktop version:

 

Stefancy_0-1635442888995.png

 

V-lianl-msft
Community Support
Community Support

Hi @Stefancy ,

 

If you apply this measure in the slicer, an error has been thrown in the desktop.

Vlianlmsft_0-1634280812403.png

 

It is recommended that you use hidden visual to meet your needs

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 


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

Hi @V-lianl-msft ,

 

I'm not sure what you mean by "if you apply this measure in the slicer."  How did you get that error?  The problem that I am having only occurs in the published report, not in Desktop. 

 

That said, while I really enjoyed that article and can see it being useful in the future, it doesn't help the current situation, as the user needs to be able to select the date fields, when available.  Having a "hidden" card in front of the custom date selection prevents input.  

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.