Forum Discussion

emmet's avatar
emmet
Frequent Visitor
7 years ago

Default Views with Visual Interactions

Hello, I have 3 possible values in a field (Yes, No, Maybe). I have a donut chart displaying the breakdown of all Yes and No values and a table below this displaying the details of all the Maybe value...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi emmet,

 

It's hard to achieve it directly. But we can add a dimension table and use a measure to filter the result. Please download the demo from the attachment.

1. Create a new table.

OptionTable = VALUES(Table1[Options])

2. Establish a relationship.

3. Create a measure. 

Measure =
IF (
    ISBLANK ( SELECTEDVALUE ( 'OptionTable'[Options] ) ),
    IF ( MIN ( 'Table1'[Options] ) = "Maybe", "Yes", BLANK () ),
    IF (
        MIN ( Table1[Options] ) = SELECTEDVALUE ( OptionTable[Options] ),
        "Yes",
        BLANK ()
    )
)

3. Add it to the Visual Level Filter. 

Default-Views-with-Visual-Interactions

 

Best Regards,
Dale