Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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!

Capture.PNG

 

Regards,

Poonam

1 ACCEPTED SOLUTION
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

View solution in original post

2 REPLIES 2
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
Not applicable

Hi @Anonymous,

 

Thank you so much !! 🙂 🙂

Both the solutions work perfectly. Really appreciate your help 🙂

 

Regards,

Poonam

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.