Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |