Forum Discussion
Sorting dates into quarters from different years
hi, Anonymous
Please refer to this screenshot:
You have to keep Year hierarchy in the visual too, otherwise, it will be aggregated in quarter hierarchy.
"however, drill down does not fix my problem.", Do not use drill down, you should use expand.
and here is a simple sample pbix file, please try it.
Best Regards,
Lin
Hi!
You're just importing it as a data source, not as a visual (in 'Get Data'- Power BI database). Think of it as another part of your data- it's just a mapping table.
Then, to create the relationship, have a look at: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Best,
Eva
Hello again Eva,
I've attached a screenshot of the list that populates from my "Get Data" tab. I do not see Power BI database - ony datasets and dataflows.
I tried to connect to datasets but it says I cannot connect to it and another data source at the same time. Can you clarify? Thanks.
Robyn