Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how can I make table 1 to table 2?
1.
a | b | a | b |
1 | 2 | 3 | 4 |
2.
a | b |
1 | 2 |
3 | 4 |
2023 data? | 2023 data? |
also, if first a and b is 2021 dataset, and second a and b is 2022 dataset, and I will add 2023 dataset, what opreation do I need so that I can have a year slicer in my report?
look like below:
year slicer |
2021 |
2022 |
2023 |
a and b slicer |
a |
b |
the report outcome:
a |
1 |
Solved! Go to Solution.
Hi @henry24007 ,
You will need to perform the unpivot all columns operation in power query. This will ensure that any other columns that you add will also be included in the operation after every refresh.
Please note that two columns cannot have the same name, so Power query will append a suffix automatically. You can simply perform a replace operation to remove the suffix.
You can then use the attribute column as the slicer in your report.
As for year, you either need to include that as a separate column in your dataset, or add a conditional column based on certain rules to map each row to a year.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi @henry24007 ,
You will need to perform the unpivot all columns operation in power query. This will ensure that any other columns that you add will also be included in the operation after every refresh.
Please note that two columns cannot have the same name, so Power query will append a suffix automatically. You can simply perform a replace operation to remove the suffix.
You can then use the attribute column as the slicer in your report.
As for year, you either need to include that as a separate column in your dataset, or add a conditional column based on certain rules to map each row to a year.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |