Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello,
I am new to developing in Power BI and am trying to replicate, as best as i can, a previous report. The report shows Revenue by quarter for two differnent time periords, Previuous Year and Curreny Year. the report then shows dollar difference and % change by quarter. However, when I set this up in a matrix, the output looks like:
Q1 | Q2 | Q3 | Q4 | |||||||||||||
PY Rev | CY Rev | $ ▲ | % ▲ | PY Rev | CY Rev | $ ▲ | % ▲ | PY Rev | CY Rev | $ ▲ | % ▲ | PY Rev | CY Rev | $ ▲ | % ▲ | |
McDonalds | ||||||||||||||||
Wendy's |
I want the report to be set up like this:
Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |
PY Rev | PY Rev | PY Rev | PY Rev | CY Rev | CY Rev | CY Rev | CY Rev | $ ▲ Q/Q | $ ▲ Q/Q | $ ▲ Q/Q | $ ▲ Q/Q | % ▲ Q/Q | % ▲ Q/Q | % ▲ Q/Q | % ▲ Q/Q | |
McDonalds | ||||||||||||||||
Wendy's |
Is there a way to reorder columns in Power BI, or does anyone have suggestions on how to present this report? Thanks!
Use 'Enter data' to create a little 4-row 2-column table. Call the table 'tblColumns':
Col_Name Order
CY Rev 1
PY Rev 2
$ Q/Q 3
% Q/Q 4
Once created, click on [Col_Name] and a 'Column Tools' tab should appear in the ribbon. Use 'Sort by column' to sort [Col_Name] by [Order]
Ensure this little table is NOT linked to anything in modelling view.
Create the following measure:
Check out the November 2023 Power BI update to learn about new features.