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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bart_Poelert
Frequent Visitor

Date slicer not able to type in text box

Hello,

 

Since the march 2022 update its no longer possible to manualy type a date in a date slicer box for our users.

When i select the imput box for the date it directly shows a date picker and im not able to change the date with the keyboard

When i publish a blank pbix to the services created with the latest version of powerbi desktop the slicer is functioning fine and as excpected. 

 

The tip i got is to open the old pbix files and republish them to the service. However the date slicers keep the old format.

Recreating all the dashboards is not a option because of the size of the files, this will take a long time.

The old reports also do not show the calander icons (see screenshot).

 

how do i update the pbix file to use the latest version of the slicer?

 

slicer visual of a new report

image.png

 

 

 

slicer visual of a old report 

image.png

 

 

 

 

 

 

 

 

 

 

 

 

Grt.

 

Bart Poelert

 

update:

I did some digging in the different pbix files by opening them with winrar.

there i see a difference in de basetheme json file 

the json is located in "Report\StaticResources\SharedResources\BaseThemes"

 

In a new file the base json is 'CY22SU03.json' (march 2022)

In my old files the base json is 'CY21SU11.json' (november 2021)

I treid replacing the file via winrar but this does not have any affect. 

How do i upgrade the old file to the new basetheme json..

 

the content of the old file json for the slicer part:

"slicer": {
			"*": {
				"general": [
					{
						"responsive": true
					}
				]
			}
		}

in the new json it looks like this:

		"slicer": {
			"*": {
				"general": [
					{
						"responsive": true
					}
				],
				"date": [
					{
						"hideDatePickerButton": false
					}
				],
				"items": [
					{
						"fontColor": {
							"solid": {
								"color": "#252423"
							}
						},
						"padding": 4,
						"accessibilityContrastProperties": true
					}
				]
			}
		}

 

1 REPLY 1
v-chenwuz-msft
Community Support
Community Support

Hi @Bart_Poelert ,

 

Can you try download the pbix file from the Power BI Service and open it with the latest version and save it as a copy. And publish the copy to replace the original report on service.

 

Best Regards

Community Support Team _ chenwu zhu

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors