Forum Discussion
Power BI dynamic visualizations
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 v-kpoloju-msft for the solution.
bit hesitate in pivoting it as the data is going to be huge, Is it possible also to add dyamic table visualizations based on columns in SelectedTableColumns. For Example if SelectedTableColumns has 3 columns then then report automatically has to create 3 table visualizations
Example : lets says we created 10 table visualizations but user has populated data only for 6 columns then the rest 4 table visualizations are going to be empty.
Other issue that i observed is when i select one of the record in one of the visualization then the data in all the visualizations within the report will be filtered but with this approach that is not the case, Any thoughts on this ?
Hi pk3130,
Thanks for the great follow-up. You have raised three very valid points especially around performance, visual flexibility, and native interactivity.
Performance concern with unpivoting large data: You are right unpivoting a wide table (like 50 columns) on a large dataset can increase memory usage. If your dataset is very large, I would recommend testing it on a sample slice to assess the impact.
Alternatively, the Field Parameters feature (explained below) avoids the need to unpivot entirely.
Dynamic number of visuals based on selected columns: Power BI does not support creating visuals dynamically. However, you can simulate this by:
- Pre-building 10 table visuals
- Applying a filter using a measure like ShowTableX to hide visuals with no data (if fewer than 10 columns are selected).
This approach gives users a clean experience by showing only the relevant visuals.
Cross-filtering between visuals: This is a known limitation with disconnected slicer-based setups or unpivoted data. Since these visuals do not share a natural relationship, clicking one does not filter the others.
To retain native cross-filtering behaviour, I would recommend exploring Field Parameters a newer feature that allows users to select multiple columns in a slicer and display them in a single table visual, while retaining native interactivity.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi pk3130,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.