Hi PowerBi Community! I'm new to this software but we are using it a lot lately in my company as its potentialities are amazing and we will try to modernize our reports in order to make the most of PowerBi efficiency.
For this I'm trying to reshape a power pivot report into a much efficient and good loking power Bi one.
About the source Data:
my dataset as a column that identifies the number of passengers for a single sector (Origin & Destination e.g. LHR to DXB). Another Column identifies if this passengers flows is from this year or last year.
What I need to do:
The new power Bi dashoboard needs to have an indicator that tells the user the variation of passengers for each single Origin&Destination Sector (they are more than 6000). This variation has to be in percentage and absolute figure.
What we have in power pivot is this:
where Mkt vLY is the percentage variation of LHRDXB 2017 vs 2016 and -0.0004 is the same but in absolute values.
What I have tried to do:
I've tried to split 2016 and 2017 data in two different tables and calculate a column that substract then divide but it did not work out.
Why the year is text? Is it text data type in Excel? Please click Query Edit, and see if the data type are changed. Change it to number data type, you will get expected result using the solution above.
If you still have problem, could you please share your sample data or more details for further analysis.