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 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
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |