Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Greetings!
Is there any way by which, I can add or delete the columns in a table visual dynamically (Based on Users' Selection) at Power BI Service Level. The report uses the Direct Query Model for the Source conectivity - SQL Server DB 2016.
(p.s. - I am aware that the Transformations are not supported in the Direct Query Model & also, I don't want the users to have the edit access as well).
Your Suggestions/Help are most welcome!
Thanks in advance. 🙂
Solved! Go to Solution.
Hi @Anonymous
For the first post I posted before, I was referring you can use the unpivot function to transform the columns, and then display it as Matrix visual, that based on the slicer, you can change the columns dynamically.
For power bi itself, it's not supported to create a dynamic column/table based on slicer vs filter. I'd like to suggest you create a dynamic measure to instead.
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
@Anonymous
Hope the feature is not available yet.
Please refer the link and vote for it.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
BR
venal.
Hi Venal,
Thanks for Highlighting this. 🙂
But, I am well aware of this fact - as i have already mentioned in my question earlier.
If there is any other possible way to acheive this. (either from Front End or the backend) then please drop your suggestions.
Thanks!
Premisha
Hi @Anonymous
Let me know if you'd like to get the results like this thread:
https://community.powerbi.com/t5/Desktop/dynamic-update-of-visuals-for-multiple-columns/m-p/873174
Hi Dina,
Thanks for the suggestion. 🙂
As I have already mentioned in my question, the report uses the Direct Query Model.
Unfortunately, the "Transform - Pivot" feature is not supported in this data model.
Thanks,
Premisha
Hi @Anonymous
Pivot is not doable in Direct Query, but I was referring unpivot function 🙂 did you try it?
Hi Dina,
By Unpivot function, are you reffering to the Union dax function to acheive the requirement ?
Thanks,
Premisha
Hi @Anonymous
For the first post I posted before, I was referring you can use the unpivot function to transform the columns, and then display it as Matrix visual, that based on the slicer, you can change the columns dynamically.
For power bi itself, it's not supported to create a dynamic column/table based on slicer vs filter. I'd like to suggest you create a dynamic measure to instead.
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
@Anonymous,
You can try with Bookmarks feature.
Please refer the below links,
https://community.powerbi.com/t5/Community-Blog/Toggle-between-a-chart-and-a-table/ba-p/312655
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Hope it will help you!
Hi Siva,
Thanks for the suggestion. 🙂
But, Bookmarks are feasible only when we have a few columns to deal with.
For 2-digit column numbers, firstly, we need to create Addition & Deletion BKs seperately for individual column.
Plus, for giving it a dynamic feel, we have to make BKs for every possible column combination selections by user.
It's a tedious work & will further affect the performance as well.