Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
HI Expert,
I have 5 filters
FilterName |
1 Month |
3 Month |
6 Month |
1 year |
I have already Created DAX formula for Percentage
by default I have selected 6 Month.
if I have selected 3 Month then we need compare 6Month vs 3 Month Percentage is greater values GREEN otherwise RED
same can selected filter one filter then should be compare previous Month selected.
I can selected any one then should be compare i am selected previous filter.
Please any own can help DAX formula.
I need creare Arrow Indicate
Thanks
Vedantika_S
Hi, could you post your data frame to visualize?
I created a dax function once:
Previous Balance =
VAR MinDate = CALCULATE( MIN('Public DimDate'[Date]), ALLSELECTED('Public DimDate'[Date]) )
RETURN
CALCULATE(
SUMX('Account FactAccountMoviment',
'Account FactAccountMoviment'[CreditValue] - 'Account FactAccountMoviment'[DebtValue])
,FILTER(ALL('Public DimDate'),'Public DimDate'[Date] < MinDate )
)
The var Mindate is possible to get the Min value from slicer, i think you have to get many dimension of date as you have in slicers to get each date.
Hope this help you
@Vedantika_V , no, we do not have a way to know the previously selected value, You have two create two slicers from two different tables and use those
refer
How to use two Date/Period slicers
User | Count |
---|---|
79 | |
74 | |
63 | |
45 | |
44 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |