dynamic columns in table

[jaweher899]

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.

[bolfri]

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?

[jaweher899]

Thank you again @bolfri, the issue is that in the real report I've around 80 measures, and for each two measures i need to calculate the variance and %of variance, so it'll too much measures..

The user expects to have separately a slicer variance and cov to click on it, then it will display variance for only the measures selected. 

(+kudo) 

[bolfri]

This is totally different logic then and issue that you didn't mention.

So you have like 80 values that can be measured and you want to user to pick 2 od them to compare and then decide if to show the difference (# and %), right?

[jaweher899]

@bolfri yes, In the sample I put only two measures to simplify my issue

[bolfri]

My answer was based on the sample data and description that you've provided. And your question didn't include such problem as choosing different measures to compare. 🙂 I think you should put more measures and discribe this problem one more time, so it will be easier for everyone to find it in the future.

[jaweher899]

hi @bolfri I put a new question, hope that I'm clearer.

[jaweher899]

@bolfri @could you please share thr pbix file and I'll check it? Thank you

[bolfri · Accepted solution]

https://we.tl/t-SQ3FDr0b9l

[jaweher899]

Thank you @bolfri, you're brilliant!

[TomMartens]

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

[jaweher899]

@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?