Forum Discussion
Impactful Individualdynamic 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
- TomMartens
Super User
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
jaweher899TomMartens 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?
- bolfri
Solution Sage
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 - jaweher899
- 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
- bolfri
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?
