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 there,
Need some help on visuals, I only want to display months in the current financial year up until the current month. I would like to see YOY but the max date must be the current month and the min the start of the financial year. I have a filter on months for financial year but stuck on cutting the visual off on the current month.
Please see below example and
Has anyone had a similar issue?
Best Regards
Solved! Go to Solution.
Thanks @Calvin69 for the reply.
Ive managed to solve it by creating a Financial Year Month Number, sorting my date table's month column with Financial Year Month Number.
I then create measures for previous Year -1 and before previous year -2, and obviously Current year.
So the graph then contains the following fields:
Axis is the sorted Month table
Values the measure for current, PY and PY2
I then filter the graph on my date using relative date to only show "is in this" year.
This seems to work. If anyone is interested in a more detailed explanation I am happy to provide more details.
Kind regards
Morning @Axiomite ,
The only way I can think of getting around this is by playing around my date table "Assuming you are using one"
I have created the following date table and used it within my visuals and it kind of worked:
Date =
ADDCOLUMNS (
CALENDAR (DATE(2019,1,1), TODAY()),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),
"TESDATE", FORMAT ( [Date], "dd/MM/YYYY")
)
Result:
Hope this helps
H
Thanks @Calvin69 for the reply.
Ive managed to solve it by creating a Financial Year Month Number, sorting my date table's month column with Financial Year Month Number.
I then create measures for previous Year -1 and before previous year -2, and obviously Current year.
So the graph then contains the following fields:
Axis is the sorted Month table
Values the measure for current, PY and PY2
I then filter the graph on my date using relative date to only show "is in this" year.
This seems to work. If anyone is interested in a more detailed explanation I am happy to provide more details.
Kind regards
Cool @Axiomite ,
Please do mark this as resolved if you require no further help with it.
Kind regards
H
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 |