DropDown option to select another chart

[Anonymous]

Hi,

I've a use case I need to put multiple charts in one place on top of other. I need a DropDown selector to choose the desired chart. How to achieve this in PowerBI? any help on this would be highly appreciated. 

Example:  https://www.google.com/imgres?imgurl=https%3A%2F%2Fstatic.wixstatic.com%2Fmedia%2F9d7f1e_b306647fe89... 

[Anonymous · Accepted solution]

Hello @MuraliPrasathS

You can achieve your goal by segmenting and measureing.

I build a table (values) like yours and build a slicer table.

Mesa:

ProductName Table(Slicer Table):

Measure:

Chart Data Source =
VAR _Sel =
    SELECTEDVALUE ( ProductName[ProductName] )
RETURN
    IF (
        ISFILTERED ( ProductName[ProductName] ),
        SWITCH (
            TRUE (),
            _Sel = "ProductA", SUM ( 'Table'[ProductA] ),
            _Sel = "ProductB", SUM ( 'Table'[ProductB] ),
            SUM ( 'Table'[ProductC] )
        ),
        BLANK ()
    )

The result is as follows.

By default, it will be blank.

Select ProductA in the slicer:

You can download the pbix file from this link: DropDown option to select another chart

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , I think you need bookmarks

https://www.youtube.com/watch?v=z9jdkyyE3WU

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive