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.
I have an indicator (let's say profit as a percentage of revenue) of which I want to display (the current month) for curent year and the previous year in a barchart. However, I want to use a slicer to define what "the current year" is. If the slicer is set to 2019, I want to see 2 bars, one with 18 and one with 19. If the slicer is set to 16, I want to see 15 and 16 etc.
I managed to do this with 2 seperate measures in the value field of the barchart (the one for the previous year below), however, that results in the same legend/axis label for the year: it always only shows the one for the "sliced" year.
%Profit M-1Y =
VAR YearMonth =
Calculate(Max( DimDate[YearMonth] ), Month( DimDate[ActualDate] ) = Month( ToDay() ) ) - 100 Return
//DimDate[YearMonth is something like 202101 for january 2021
Calculate( Profit[%Profit], Filter( All( DimDate), Int(Value(DimDate[YearMonth])) = Int(YearMonth) ) )
(The measure for current year is identical, without the -100.)
Is there any way to do this just using only a single measure, overriding the slicer?
Thanks in advance!
Solved! Go to Solution.
Hi @mmpbi,
If you want to achieve a custom filter range that different from you operation on the slicer, you need to ignore the filter effect from slicer to your table.
Then you can write a measure to check current row contents and compare with extracted slicer selection items to return tag. After these steps, you can use this measure as a visual level filter to filter records.
Applying a measure filter in Power BI
Regards,
Xiaoxin Sheng
Hi @mmpbi,
If you want to achieve a custom filter range that different from you operation on the slicer, you need to ignore the filter effect from slicer to your table.
Then you can write a measure to check current row contents and compare with extracted slicer selection items to return tag. After these steps, you can use this measure as a visual level filter to filter records.
Applying a measure filter in Power BI
Regards,
Xiaoxin Sheng
Hi,
See if you can get some help from my article here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Thanks for your reply, but I do not see how this solves my solution. It's about and excel and only remotely related.
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |