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,
The date table stays forever. It just has every date you could ever need (mine runs from 2005 to 2025) and maps it to a month, a quarter, a year, whatever you need.
You just import it every time you create a Power BI report which uses dates, and create a relationship between the date table and the column in your database that has your dates.
Eva
Hello Eva,
I apologize as I am new to DAX tables. Do I import this file as a new visualization? When I try to import, PBI looks for visual files (*.pbiviz) however, this file downloads as a .pbit and .pbix. I'm a little confused how to import this into my existing .pbix visual dashboard. If you could break it down into steps, I'd appreciate it. Thanks!
Robyn
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