Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Vedantika_V
New Member

previous selected values and copare to current selected values less than RED

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

2 REPLIES 2
RafaelRSantos_
Frequent Visitor

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

amitchandak
Super User
Super User

@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

https://youtu.be/WSeZr_-MiTg

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.