Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! I have a table that has 5 columns.
Column 1 is the name of the product.
Column 2 Total annual sales of a product for the current year (2018)
Column 3 Total annual sales of a product for the year before the current one
Column 4 Total annual sales of a product for 2 years prior to the current one
Column 5 Total annual sales of a product for 3 years prior to current
I need the name of the column to be equal to the calculated year. But it can not be a fixed value, since next year (2019), the names should be: Column 2: 2019 Column 3: 2018 Column 4: 2017 Column 5: 2016 And so on as the years change. I achieved this behavior by adapting a visual object "card", but I lose the functionality of the ordering table from highest to lowest, since it is covered by the visual object. I imagine that there is some way to achieve this in another way. Can you tell me how? Thank you
Hi psembaj,
Have you solved your issue? Could you kindly mark one answer to finish this case?
Regards,
Jimmy Tao
Hi psembaj,
Could you share some sample data and clarify more details about your expected table format?
Regards,
Jimmy Tao
The shape of your data is not optimal for power BI. You should unpivot the columns so you have a column called year and another column called value. You can do this in power query. You will then need to apply some logic in your query to set the correct values for each year.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |