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
jbird258
Frequent Visitor

How to filter a Time Intelligence Function

Screenshot 2023-02-19 221540.png

My issue is, I have a matrix visual with two columns. The first column is a simple sum that returns either a number or a blank depending on the slicer settings.  The second column is a time intelligence function showing the change from last month, which returns a number for each row.

 

What I want is for the second column (change from previous month) to only return a value when there is a value present in the first column, (Otherwise return blank). What is partly tripping me up is that the previous month function needs access to 'old' data, so I cannot just filter to current conditions as these conditions will not be accurate to last month also.

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @jbird258 try to add a IF condition in your last step of change from previous month, like

 

 

change from previous month =

....

VAR _value =

...

RETURN

IF([Amber Count]=BLANK(), BLANK(), _value)

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @jbird258 try to add a IF condition in your last step of change from previous month, like

 

 

change from previous month =

....

VAR _value =

...

RETURN

IF([Amber Count]=BLANK(), BLANK(), _value)

@FreemanZ, thanks for taking the time to respond, much appreciated. Worked a treat

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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