cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sportynick Frequent Visitor
Frequent Visitor

Button on dashboard to open up editing for Matrix visual data

Hi all,

Challenge: Currently have three matrix visuals on a dashboard each displaying data from different tables. To edit the data, i need to do: (i) Click "Edit Queries" --> (ii) Select relevant table from "Queries" --> (iii) Double-click conditional column previously added in "Applied Step". Would like to place a button next to each matrix visual and upon clicking,  opens up the conditional column view in (iii), allowing for data editing.

Am thinking upon the lines of how a macro is created by recording steps and assigned to a button in Excel. Is this doable in Power BI? If doable, would the buttons work when publised to Power BI Service?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Button on dashboard to open up editing for Matrix visual data

No, you can’t do it. There is no vba in power BI. Power BI is not really designe to “create” data, it is to report on data. Proabaly the easiest Way to add data is to do it in an excel sheet and import from there. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

1 REPLY 1
Super User
Super User

Re: Button on dashboard to open up editing for Matrix visual data

No, you can’t do it. There is no vba in power BI. Power BI is not really designe to “create” data, it is to report on data. Proabaly the easiest Way to add data is to do it in an excel sheet and import from there. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 70 members 948 guests
Please welcome our newest community members: