Forum Discussion
dynamic columns in table
I've the following pbix file https://1drv.ms/u/s!Amd7BXzYs7AVk3D5iDMIrhfnpQNW?e=lHWRuH
when the user select in colun name %var, it'll add the measure %var n the table and only when both intial.subtotal and table1.Initial subtotal are selected.
for example here when initial.subtotal is not selected and %var is selected, so %var will not be added to the table
In case of I select var and % var , both measures should be displayed.
In case of I select nothing for the slicer column name,var and %var should not be dispalyed.
I try to find a solution since two weeks, if someone can help me, it'll be much appreciated.
13 Replies
Hey jaweher899 ,
it's simply not possible to show a column based on conditions.
The only thing that is close is the field parameters feature: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
Regards,Tom
TomMartens thank you for your reply. I alredy use field parameter in the table in the pbix file. Could you please show how to use another field parameter in the same table?
This is what you want?
User picks Show in the table %var %var %var Initial Subtotal %var Table1.Initial Subtotal %var & var var %var & var %var Nothing - Thank you for your reply bolfri.When the user select %var, he should choose both initial subtotal and table1. Initial subtotal in order to show three measures initial subtotal and table1. Initialnsubtotal and %var.
- If the user chooses %var and only initial subtotal, so in the table i need to show only initial subtotal
Hope that I'm clear, thank you
The problem here is that you're expecting from end user that he nows the correct combinations of filters. It's easier to provide him a correct options right now.
Subtotal 1 = SUM(FactSales[Initial Subtotal])Subtotal 2 = SUM(FactSales[table1.Initial Subtotal])Difference = [Subtotal 1] - [Subtotal 2]% Difference = DIVIDE([Difference],[Subtotal 2])Possible solution: Can you accept something like this?
