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 all,
I have a question regarding column name changes. I am trying to build a report that will give quarterly data and would like the month names in the matrix column headers to change accordingly.
For example:
when Q1 then mnth1=Jan, mnth2 = Feb, mnth3 = March
when Q3 then mnth1= Jul, mnth2 = Aug, mnth3 = Sep
Has anyone ran into this before or have an idea on how to do it?
Thank you for the help in advance!
There's no such dynamic column name in Power BI, AFAIK. However you could play matrix visual with some tricky. See mode details in the attached pbix.
Hello @Eric_Zhang,
Sorry for the late response (needed admin's permission), but it didn't work for me. Your example seems to do what I wanted, so it may be due to the way my data is set up and I may just need to change a couple things. Thank you for your help!
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |