Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create Action on Text/Image/Button in Power BI

Hi,

 

I am very new to Power bi. I have one requirement. I have below few columns in the database.

1) Forecast Category

2) Market

3) Market Unit

4) BU

5) BL 

Instead of creating different views for each of those. I want to create action by providing all above column as Text/Image/Button.

I have created Stacked column chart.

When I click on 'Forecast Category' it should show 'Forecast category' as a legend.

When I click on 'Market' it should show Market legend. Is there any way to do that?

Below is the view I created based on 'Market' legend.

Can anyone help me on this? Thanks!

 

Regards,

Poonam

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

    I have two alternative solutions for you-

    1. By using some transformation(Unpivoting the Forecast Category, Market, Market Unit etc Column)
    2. By using the bookmark(Creating button)

    For more details see the pbix file. Hope this will help you!!!

    Download pbix file

     

    Regards,

    Angad

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous

    I have two alternative solutions for you-

    1. By using some transformation(Unpivoting the Forecast Category, Market, Market Unit etc Column)
    2. By using the bookmark(Creating button)

    For more details see the pbix file. Hope this will help you!!!

    Download pbix file

     

    Regards,

    Angad

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous,

       

      Thank you so much !! :) :)

      Both the solutions work perfectly. Really appreciate your help :)

       

      Regards,

      Poonam