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
DirkFrazier
Advocate I
Advocate I

Personalize Visual Only Date Column Hierarchy Available

When using the Personalize this visual option in the Power BI Service, all Date columns are represented as a Date Hierarchy. How do I let users pick a single column of the respective Date field, without forcing them to pick the Year, Month, and Day parts for each Date column they want to include in the visual?

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

Hi @DirkFrazier 

You need to close the Time intelligence of the current report on Power BI Desktop before publish it to Power BI Service, then the user will only see date column instead of date hierarchy in Power BI Service.

Operation:

Open Power BI Desktop->File->Options and Settings->Options->Current File->Data load->Time intelligence

Then close it.

vxinruzhumsft_0-1691117982999.png

 

Best Regards!

Yolo Zhu

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

2 REPLIES 2
sergej_og
Super User
Super User

Best practise to switch off "auto date/time", as @v-xinruzhu-msft mentioned.
In best case you can use a "calender dimension table" and provide year, month etc. columns to your users.
This is how you can achieve your desired solution.

v-xinruzhu-msft
Community Support
Community Support

Hi @DirkFrazier 

You need to close the Time intelligence of the current report on Power BI Desktop before publish it to Power BI Service, then the user will only see date column instead of date hierarchy in Power BI Service.

Operation:

Open Power BI Desktop->File->Options and Settings->Options->Current File->Data load->Time intelligence

Then close it.

vxinruzhumsft_0-1691117982999.png

 

Best Regards!

Yolo 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