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.
Hello,
I need to build a pivot table where the column section is based on Date Hierarchy as well as Country. I want the country to be fixed (Always showing up) where as the date part to come in hierarchy, i.e. drilling down from Year to weekly view. Is there any way I can achieve this ?
Even if there is a solution where I can modify values in the backend, that is appreciated as well
Solved! Go to Solution.
To achieve that you would need to put the country at the top of the hierarchy.
To achieve that you would need to put the country at the top of the hierarchy.
Is there any way we can make the Country field fixed ? so that it doesn't pop out? no matter how much we drill up
Did you consider my suggestion?
Yes I did, I worte it worng, it wasn't country but date also that I want to fix to the top most level (year) along with country, so that it doesn't pop out of the visual.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |