Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
I created a report based on the following time period. I am comparing two time periods as below:
April 2019 to March 2020
Please note: Values of Jan , Feb & March is from 2020.
Jan | Feb | March | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|
|
|
|
|
|
|
|
|
|
|
|
April 2020 to Now
Please note: Values of Jan , Feb & March is from 2021.
Jan | Feb | March | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|
|
|
|
|
|
|
|
|
|
|
|
Please note:
Values in the month of Jan Feb & March is from lastest year. April to Dec is from Previous year.
I want to display matrix as below:
April 2019 to March 2020
Please note: Values of Jan , Feb & March is from 2020.
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | March |
|
|
|
|
|
|
|
|
|
|
|
|
April 2020 to Now
Please note: Values of Jan , Feb & March is from 2021.
Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | March |
|
|
|
|
|
|
|
|
|
|
|
|
Your help will be apprciated.
SD
Solved! Go to Solution.
HI @sdhn,
I'd like to suggest you create a custom sorting order table and link to raw table fields and use new table fields on your chart to achieve custom sort order.
Regards,
Xiaoxin Sheng
HI @sdhn,
I'd like to suggest you create a custom sorting order table and link to raw table fields and use new table fields on your chart to achieve custom sort order.
Regards,
Xiaoxin Sheng