Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
Since i am working on a financial dataset, the first quarter for a year is between April and June whereas in Power BI the default quarter option in date hierarchy refers Qtr1 from Jan - Mar. Is there any other shortcuts apart from adding a calculated column with if/switch case logic. I am trying to avoid a calculated column as it increases the time for refresh when working on live data.
hi @Vyshak
It could not achieve that change the starting month of Quarter in built-in date hierarchy.
You could only define it in new column with sort by column and custom a new custom date hierarchy instead of built-in date hierarchy.
https://radacad.com/sort-by-column-in-power-bi
Regards,
Lin
Do you know how to get this to work on a line chart to allow a trend line also? I need to show the count by Year (starting April) and Qtr, with a trend line. Thanks
@Vyshak , I doubt that. I logged an idea for that. Vote for that.
Quarter with Year End Date
https://ideas.powerbi.com/ideas/idea/?ideaid=b1be6e59-4ad0-4562-826c-5ac5ab3f0f3c
You should do that only in your calendar use from there.
refer any month calendar to do that : https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
oh okay Amit. Will Vote for that idea. thanks
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
121 | |
73 | |
73 | |
63 |