Forum Discussion

DirkFrazier's avatar
DirkFrazier
Advocate I
3 years ago
Solved

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, with...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.