cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nick_Church Frequent Visitor
Frequent Visitor

Dashboard filter that allows users to determine the measures they want to see

 

Hi,

 

I'm fairly new to PowerBI, so I'm pretty sure this must be an easy one but I can't find any answers after a bit of googling!

 

So my issue is that I want to create a filter that allows a dashboard / report user to decide what measures they want to see.

 

Context for this is that I have a line graph which is currently plotting FY17, FY18 and FY18 Budget figures.

 

I want the intial version of the report to return the FY17 vas F18 figures to see how we perform relative to last year. However I want the users to have th ability to bring in the budget lines should they choose.

 

Any ideas would be appreciated.

 

Thanks

 

Nick

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: Dashboard filter that allows users to determine the measures they want to see

@Nick_Church,

 

I have tested it on my local environment using my sample data.
Capture.PNG

Create a table by enter data.
Capture1.PNG

Add the column to a slicer, and create a measure in original table.

Measure =
VAR SelectedItem =
    IF (
        ISFILTERED ( Slicer[Slicer] ),
        CONCATENATEX ( VALUES ( Slicer[Slicer] ), Slicer[Slicer], "" ),
        "FY17FY18"
    )
VAR Check =
    IF ( ISERROR ( SEARCH ( MAX ( Table1[Attribute] ), SelectedItem ) ), 0, 1 )
RETURN
    Check

Use this measure in your line chart filter.
Capture2.PNGCapture3.PNGCapture4.PNG

 

If this is not what you want, please elaborate your issue so that we can make further analysis.

 

Regards,

Charlie Liao

2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: Dashboard filter that allows users to determine the measures they want to see

@Nick_Church,

 

I have tested it on my local environment using my sample data.
Capture.PNG

Create a table by enter data.
Capture1.PNG

Add the column to a slicer, and create a measure in original table.

Measure =
VAR SelectedItem =
    IF (
        ISFILTERED ( Slicer[Slicer] ),
        CONCATENATEX ( VALUES ( Slicer[Slicer] ), Slicer[Slicer], "" ),
        "FY17FY18"
    )
VAR Check =
    IF ( ISERROR ( SEARCH ( MAX ( Table1[Attribute] ), SelectedItem ) ), 0, 1 )
RETURN
    Check

Use this measure in your line chart filter.
Capture2.PNGCapture3.PNGCapture4.PNG

 

If this is not what you want, please elaborate your issue so that we can make further analysis.

 

Regards,

Charlie Liao

Nick_Church Frequent Visitor
Frequent Visitor

Re: Dashboard filter that allows users to determine the measures they want to see

Thats awesome - thanks so much!