Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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:
Regards,
Xiaoxin Sheng
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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |