topic Re: How to Show a Conditional Column on a Dash Table? in Developer

How to Show a Conditional Column on a Dash Table?

smartcompany — Thu, 18 Nov 2021 14:14:30 GMT

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

Re: How to Show a Conditional Column on a Dash Table?

Anonymous — Mon, 22 Nov 2021 06:13:37 GMT

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 Power BI

Regards,

Xiaoxin Sheng

Re: How to Show a Conditional Column on a Dash Table?

smartcompany — Mon, 22 Nov 2021 14:38:43 GMT

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.

Re: How to Show a Conditional Column on a Dash Table?

Anonymous — Thu, 25 Nov 2021 06:57:08 GMT

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