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.
Hi
How can i name Academic year Sep till Nov as Q1 and Dec till Jan Q2 so on and so forth? I tried to use switch statement on date dimension, but that changes the count of data on each quarter completely. So, i don't want to change anything on the date dimension, but i just want to name the month ranges like Sep till Nov as Q1 and Dec till Jan Q2 etc.
Hoping to get some help on this.
Thanks
Solved! Go to Solution.
you can create an academic year quarter column or academic year column to fix this.
Proud to be a Super User!
you can try this
academic year = switch(TRUE(),
'date'[month] in {9,10,11},"Q1",
'date'[month] in {12,1,2},"Q2",
'date'[month] in {3,4,5},"Q3",
"Q4")
Proud to be a Super User!
Hi Ryan,
Thanks for your help. I tried this swich statement before Asalaam well, but on the visualization it is changing the data. By using this switch statement it brings the 2019 Q4 from the original visualization to Q1. Same for 2020 it brings the Q4 from the first column chart to Q1 after the switch statement. I don't know how i can fix it.
Some help on this will be much appreciated.
Thanks
you can create an academic year quarter column or academic year column to fix this.
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |