Filtering issue using dis connect table

[Anonymous]

Hi Expert

I am trying to filter the table as shown, once you open up the attached pBIX file. if the user selects upward trend the filter the table to show upward facing arrows only and like wise if downward trend is select then downward facing arrow and the No Trend is No Trend is nothing is select from the slicer the default.

https://www.dropbox.com/s/w4p1z5ueibwrwxd/Sample__Test.%281%29.pbix?dl=0

[sturlaws · Accepted solution]

You could try something like this:

First create a new table/dimension called dimTrend like this
Trend_id  Trend

1              Up

2              Down

3              No trend

dimTrend should not have any connections to any other tables.

Create a measure like this

trendFilter =
IF (
    HASONEVALUE ( dimTrends[Trend] );
    IF ( SELECTEDVALUE ( dimTrends[Trend] ) = [__trend]; 1; 0 );
    1
)

and add the dimTrend[Trend]-column to a slicer. Add the [trendFilter]-measure to the visual you want to filter, and set to filter on [trendFilter]=1.

The measure will return 1 if more than 1 value is selected in the slicer. If only 1 value is selected, only the trends which corresponds with the trend selected, will get the value 1.

[Anonymous]

sturlaws.

many thanks much appreciated for the excellent feedback.