Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DropDown option to select another chart

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_b306647fe89d4a35b5fa724163a990f3~mv2.gif&imgrefurl=https%3A%2F%2Fwww.powerusersoftwares.com%2Fpost%2F2018%2F08%2F03%2Fhow-to-create-dynamic-charts-linked-to-a-drop-down-list-in-excel&tbnid=AyV4toTanGdiLM&vet=12ahUKEwj22Yjnye3sAhXLHXIKHfOsCSkQMygAegUIARCkAQ..i&docid=wV_JhuFfNinerM&w=600&h=275&q=excel%20drop%20down%20change%20chart&hl=en&ved=2ahUKEwj22Yjnye3sAhXLHXIKHfOsCSkQMygAegUIARCkAQ 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello @MuraliPrasathS

    You can achieve your goal by segmenting and measureing.

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

    Mesa:

    1.png

    ProductName Table(Slicer Table):

    2.png

    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.

    3.png

    Select ProductA in the slicer:

    4.png

    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.

2 Replies