Forum Discussion
Solved
Power BI dynamic visualizations
We have a predefined list of columns (e.g., Col1 to Col50) from which users can select multiple columns. The report includes 10 table visualizations, and each one should display data from one of the ...
Power BI cannot work with encrypted Excel files.
Confidential - Microsoft Extended:DESCRIPTION Data is classified and protected. Microsoft Full Time Employees (FTE) and non-employees can edit, reply, forward and print. Recipient can unprotect content with the right justification.
Thanks lbendlin
As requested here is the file. It has three sheets.
Input1-MainTable : This is the main table which has the customer data of all the columns
input2-UserselectedColumns : This is the table where we will load only the required columns based on the user selection, inshort this table will have columns that are required to show in Visualizations.
Ouput : Exepcted Table Viz
https://docs.google.com/spreadsheets/d/1XgzhaHq1wA1k0X6jEvjWbo-EOzUPCNAH/edit?usp=sharing&ouid=100891880143872369067&rtpof=true&sd=true
Power BI cannot work with encrypted Excel files.
Confidential - Microsoft Extended:DESCRIPTION Data is classified and protected. Microsoft Full Time Employees (FTE) and non-employees can edit, reply, forward and print. Recipient can unprotect content with the right justification.