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
Sportynick
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

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 an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

1 REPLY 1

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 an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.