Forum Discussion
Send object to the back with dax
I have a page I want to hide for certain users. One work around I have found is to add a square over the data so that it cannot be seen. Here is the code I used to make that square transparent:
I solved this issue by using this tutorial Using Conditional Formatting to Display a Message Instead of a Blank Visual | parry2k
I was able to do a measure
Color Text = "#FFFFFF" &IF(SELECTEDVALUE('User Master List'[Type]), "00" )Then connect that to my visuals via the font color formula on the data labels. If the wrong user is connected, the visuals will say error.
6 Replies
- lbendlin
Super User
Page level security does not exist. Don't waste your time.
It is not possible to change the Z order programmatically. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
Would it be possible to hide the page and link a button to it and program the button to go to that page if they are the correct user?
- lbendlin
Page level security does not exist. Don't waste your time.
Use separate reports if needed. (Only if truly needed)
I solved this issue by using this tutorial Using Conditional Formatting to Display a Message Instead of a Blank Visual | parry2k
I was able to do a measure
Color Text = "#FFFFFF" &IF(SELECTEDVALUE('User Master List'[Type]), "00" )Then connect that to my visuals via the font color formula on the data labels. If the wrong user is connected, the visuals will say error.- lbendlin
Again, this is just cosmetics. The user can still see the data when they connect to the semantic model.
- parry2k
arichmond glad to hear it was helpful. I think I have a couple of videos on this on my channel:
Color transparency and conditional formatting is VERY powerful Part 1 - Power BI (youtube.com)
