How to Show a Conditional Column on a Dash Table?

[smartcompany]

Hello, guys! How are you doing? 

I have a single report for many different clients (we separate them by clientID on Embedded).

So, there is a client who needs to see a column called "CostCenter" in a table, but he is the only one who needs to see it. 

There is a way to show this coloumn just for him? I mean, I don't want a empty column for other clients.

Thank you for your help! ;D

[Anonymous]

Hi @smartcompany,

Did you mean the object-level security? If that is the case, please refer to the following document to know more about this feature:

Announcing public preview of Object-Level Security in Power BI | Microsoft Power BI Blog | Microsoft...

Regards,

Xiaoxin Sheng

[smartcompany]

Hello! Thank you for your answer!

But, actually, I'm not talking abaout OLS. As I said, we use Power BI Embedded and OLS dosen't work with that (as far as I know).

I need something like a conditional filter. For example: If clientID has "hasCostCenter" (boolean value), then show this column on a table in dashboard. 

[Anonymous · Accepted solution]

HI @smartcompany,

Perhaps you can configure a custom replace function in the query editor and use parameters to control when to replace these field values to blank.

Solved: Replace value in Power Query based on condition - Microsoft Power BI Community

#"Replaced Value" = Table.ReplaceValue(#"Changed Type",each [Column],each if parameter= true then "" else [Column],Replacer.ReplaceText,{"Column"})

Regards,

Xiaoxin Sheng