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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
vishnu-Prasad
Frequent Visitor

Header columns having dates with decimal values

Hi,

 

I'm having header columns as Dates with values as decimals. Need to create a table visual with date slicers. pls help..

vishnuPrasad_0-1685607196070.png

 

Thanks

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @vishnu-Prasad ,

If you don't want to unpivot the table, you can use fields parameters like this:

vyanjiangmsft_0-1685953302152.png

Put the date columns into fields.

vyanjiangmsft_1-1685953375928.png

A parameter slicer is created automatically like below.

vyanjiangmsft_2-1685953441627.png

 

Best regards,

Community Support Team_yanjiang

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

 

View solution in original post

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

Hi @vishnu-Prasad ,

If you don't want to unpivot the table, you can use fields parameters like this:

vyanjiangmsft_0-1685953302152.png

Put the date columns into fields.

vyanjiangmsft_1-1685953375928.png

A parameter slicer is created automatically like below.

vyanjiangmsft_2-1685953441627.png

 

Best regards,

Community Support Team_yanjiang

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

 

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors