Forum Discussion
Column Customization to include show/hide columns
Column Customization needs to hide some column based on the requirement: Based on filters to display the columns
For example when you select A in filters columns should show 1,2,3,4,5
or when you select B in filters rows columns show 2,3,4,5,6 and removed 1 row
or when you select c in filters rows columns show 1,3,4,5,6 could show
Note : without out bookmark or withouts filters is possible could help me on it
Hey Anonymous ,
not sure if I understand your requirement exactly, but I assume you can achieve this using the new field parameters feature: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs
And some data modeling
I created a simple table with columns col1, col2, col3 and amount
I created a table called parameter using the parameter fields feature:I created a table called slicer
I created a table called unique columns, this table can be hidden in the report view, but is essential for creating the relationships
The data model looks like this:
This is how it looks like in action:
Here you will find the pbix: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/Ebz1SZzRM_5PiWsOt0XOBUgBW56ilmLV0jMJEtFF7xTsxg?e=mISueC
Hopefully, this is what you are looking for.
Regards,
Tom
2 Replies
Hey Anonymous ,
not sure if I understand your requirement exactly, but I assume you can achieve this using the new field parameters feature: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs
And some data modeling
I created a simple table with columns col1, col2, col3 and amount
I created a table called parameter using the parameter fields feature:I created a table called slicer
I created a table called unique columns, this table can be hidden in the report view, but is essential for creating the relationships
The data model looks like this:
This is how it looks like in action:
Here you will find the pbix: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/Ebz1SZzRM_5PiWsOt0XOBUgBW56ilmLV0jMJEtFF7xTsxg?e=mISueC
Hopefully, this is what you are looking for.
Regards,
Tom
Giving a provision of selecting columns is actually possible using the new feature called field parameter.
See if it caters to your requirement.
