Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer/Filter help needed

We have a series of projects, split into different operating areas of the Business and each project sits in only one group. We also indicate, on each project, which are under review or not and what s...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    We can create some calculated tables and add them as slicers.

    BA Slicer = VALUES('Table'[Business Area (x10)])
    LC slcier = VALUES('Table'[Lifecycle Stage (x 4)])
    PN slicer = VALUES('Table'[Project Name])
    RS slicer = VALUES('Table'[Review Status (x 2)])

    Atfer that, We can create a measure as below and put it into the  table visual.

    Measure =
VAR ba =
    VALUES ( 'BA Slicer'[Business Area (x10)] )
VAR lc =
    VALUES ( 'LC slcier'[Lifecycle Stage (x 4)] )
VAR res =
    VALUES ( 'RS slicer'[Review Status (x 2)] )
RETURN
    IF (
        OR (
            MAX ( 'Table'[Project Name] ) = "Freeze Plan",
            MAX ( 'Table'[Business Area (x10)] ) IN ba
                && MAX ( 'Table'[Lifecycle Stage (x 4)] ) IN lc
                && MAX ( 'Table'[Review Status (x 2)] ) IN res
        ),
        1,
        BLANK ()
    )

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can create some calculated tables and add them as slicers.

BA Slicer = VALUES('Table'[Business Area (x10)])
LC slcier = VALUES('Table'[Lifecycle Stage (x 4)])
PN slicer = VALUES('Table'[Project Name])
RS slicer = VALUES('Table'[Review Status (x 2)])

Atfer that, We can create a measure as below and put it into the  table visual.

Measure =
VAR ba =
    VALUES ( 'BA Slicer'[Business Area (x10)] )
VAR lc =
    VALUES ( 'LC slcier'[Lifecycle Stage (x 4)] )
VAR res =
    VALUES ( 'RS slicer'[Review Status (x 2)] )
RETURN
    IF (
        OR (
            MAX ( 'Table'[Project Name] ) = "Freeze Plan",
            MAX ( 'Table'[Business Area (x10)] ) IN ba
                && MAX ( 'Table'[Lifecycle Stage (x 4)] ) IN lc
                && MAX ( 'Table'[Review Status (x 2)] ) IN res
        ),
        1,
        BLANK ()
    )

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-frfei-msft , thanks for the solution, I've managed to get most of the way through but one step is causing me problems, namely, how did you create the "Table" with the Business Area, Lifecycle Stage, Project Name and Review Status in.  I understand the Measure, but the actual creation of "Table" has me stuck.

 

Thanks again

Fred