Personalize Visual Only Date Column Hierarchy Available

[DirkFrazier]

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?

[sergej_og]

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 · Accepted solution]

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.

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.