PowerBI Service shows different slicer than Desktop

[Delphia]

Hi!

Need your help with one very strange behaviour.

I have a period date slicer with one of the options "Custom". I have two slicers: "Period" and one with "Date" for custom selection.

On my desktop version, I have the expected behaviour of slicers: if I choose a predefined period (3 months), I couldn't choose anything in Custom Date Range. 

Nevertheless, when I publish it, instead of "dd/mm/yyyy" I see "0" and this field is available for editing...

My Period DAX looks like:

Period = 

VAR _Today = TODAY()
VAR _3months_min_date = EOMONTH(_Today,-4)+1
VAR _6months_min_date = EOMONTH(_Today,-7)+1
VAR _12months_min_date = EOMONTH(_Today,-13)+1
VAR _max_date = EOMONTH(_Today,-1)

RETURN

UNION (
   ADDCOLUMNS( SUMMARIZE( 
            CALCULATETABLE('Date', 
                DATESBETWEEN('Date'[Date],
                    MINX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_3months_min_date) && INT('Date'[Year]) = YEAR(_3months_min_date)), 'Date'[FiscalFirstDayOfMonth]), 
                    MAXX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_max_date) && INT('Date'[Year]) = YEAR(_max_date)), 'Date'[FiscalLastDayOfMonth])
                )
            ), [Date]),"Period","Last 3 Months","Sort",1),
   ADDCOLUMNS( SUMMARIZE( 
            CALCULATETABLE('Date', 
                DATESBETWEEN('Date'[Date],
                    MINX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_6months_min_date) && INT('Date'[Year]) = YEAR(_6months_min_date)), 'Date'[FiscalFirstDayOfMonth]), 
                    MAXX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_max_date) && INT('Date'[Year]) = YEAR(_max_date)), 'Date'[FiscalLastDayOfMonth])
                )
            ), [Date]),"Period","Last 6 Months","Sort",2),
    ADDCOLUMNS( SUMMARIZE( 
            CALCULATETABLE('Date', 
                DATESBETWEEN('Date'[Date],
                    MINX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_12months_min_date) && INT('Date'[Year]) = YEAR(_12months_min_date)), 'Date'[FiscalFirstDayOfMonth]), 
                    MAXX( FILTER('Date', INT('date'[FiscalMonth]) = MONTH(_max_date) && INT('Date'[Year]) = YEAR(_max_date)), 'Date'[FiscalLastDayOfMonth])
                )
            ), [Date]),"Period","Last 12 Months","Sort",3),
    ADDCOLUMNS( 
        CALENDAR(MIN('Date'[Date]), MAX('Date'[Date])),
            "Period","Custom","Sort",4)
)

Thank you in advance for your help!

Alina

[AllisonKennedy]

@Delphia  Are you using this method described here: https://www.youtube.com/watch?v=fKygF7VEJnQ 

Can you share a sample file for us to test and see if we can replicate the issue (remove sensitive data)?

[Delphia]

@AllisonKennedy ,

yes, I did exactly as in this video. Please find my pbix here:

https://drive.google.com/file/d/1NhCuMvODXR6UZj76CgpreLP1fASZBEYm/view?usp=sharing

Thank you!

[AllisonKennedy]

@Delphia 

I get the same behaviour when I publish. You could try to submit a support case and see if they can provide any additional useful info behind the scenes. 

Otherwise, just try to make the conditionally formatted title more clear? 
UPDATE: I should specify that the field looks like it's available for editing, but it doesn't actually work or do anything if you try to edit, so the core functionality still existis... just not pretty.

This method also only works if you clear the Custom filter first before choosing a different filter - correct? So that also needs a bit of explaining. 

Both things can be taught if necessary. 

Otherwise you may be able to use buttons to improve the User Experience,but it will require more manual coding....