cancel
Showing results 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

Frequent Visitor

## Change column value based on slicer

I have a table with months and showing amounts and a measure comparing last month and this month's amount:

 Month This Month Not This Month Amount Measure: Amount - Lastmonth amount 1-Jan TRUE FALSE 500 0 1-Feb FALSE TRUE 700 200 1-Mar FALSE TRUE 400 -300

When I select the month for the slicer, I would like to have a measuer or a column to show the following:

if the selected month is xx month, the value should be the [This Month]. If not, the value of [Not This Month].

Example: selected month is February via slicer, the table should show this (new measure picks up not this month from jan and this month value from feb):

 Month Amount Measure: Amount - Lastmonth amount New Measure 1-Jan 500 FALSE 1-Feb 700 200 FALSE 1-Mar 400 -300 TRUE

1 ACCEPTED SOLUTION
Community Support

Hi @Pat8 ,

You need to create a disconnected table as a slicer,

``slicer = DISTINCT('Table'[Month])``

then create the following measure:

``Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())``

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

Hi @Pat8 ,

You need to create a disconnected table as a slicer,

``slicer = DISTINCT('Table'[Month])``

then create the following measure:

``Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())``

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Champion

Hello @Pat8 ,

You may try this:

Selected Measure =
VAR _PrevMonth = PREVIOUSMONTH('Table'[Month])
VAR _Calc =
SELECTEDVALUE('Table'[Amount]) - CALCULATE(SUM('Table'[Amount]),PREVIOUSMONTH('Table'[Month]))
VAR _Check = IF(NOT ISBLANK(_PrevMonth),_Calc)
RETURN
_Check

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

https://www.vivran.in/

Frequent Visitor

Thanks for the reply! What I need is the TRUE/FALSE based on the selected month on the slicer.