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 folks,
I created a slicer to show the quarters but the slicer shows the numbers for each quarter i.e 1 2 3 4, however, I want this to be Q1, Q2, Q3 and Q4. I decided to use the concatenate function but the function takes only the text values and not the column reference. Any ideas how I can achieve this? I'll appreciate your help.
Thanks!
Solved! Go to Solution.
For some reasons your formula was not working but it gave me a hint. I just used switch function and it worked, so I added a a new column to the table with the switch formula mentioned below and it is now showing me what I wanted, but thanks a lot for taking the time out to look into my question. You deserve a kudos.
Hi @kashahzad ,
Create a Calculated Column in your Calendar Table.
QuarterName =
"Q"
& INT (
DIVIDE (
Calendar[MonthOfYear],
4
)
) + 1
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
If you are trying to add a column, you could use
Thank you for looking into it, I do not have the column with dates, I have separate columns for months, quarters and years, so this function does not fit.
Can you show what your columns look like?
You could try this:
Quarter =
VAR MonthName = Dates[Month]
VAR Result =
SWITCH (
TRUE (),
MonthName IN { "January", "February", "March" }, "Q1",
MonthName IN { "April", "May", "June" }, "Q2",
MonthName IN { "July", "August", "September" }, "Q3",
"Q4"
)
RETURN
Result
or
just used use Ampersand to concatenate: "Q " & QuarterOfYear
For some reasons your formula was not working but it gave me a hint. I just used switch function and it worked, so I added a a new column to the table with the switch formula mentioned below and it is now showing me what I wanted, but thanks a lot for taking the time out to look into my question. You deserve a 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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |