Send object to the back with dax

[arichmond]

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: 

Hide Teacher Data = IF(SELECTEDVALUE('User Master List'[Type]) IN{"Other"}, "#02102D","#FFFFFF00")

However, I then lose functionality of the page as it now has a transparent box in front of it when the user is allowed to see it. Is there a dax code I could use to also move that shape to the back of the visuals so that the page becomes interactive and move it to the front if not allowed. Something like: 

Hide Teacher Data = IF(SELECTEDVALUE('User Master List'[Type]) IN{"Other"}, "#02102D","#FFFFFF00") IF(SELECTEDVALUE('User Master List'[Type]) IN{"Other"}, "zorder back,"zorder front")

[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)

Conditional Formatting and Transparency to develop user friendly reports Part II - Power BI (youtube...

[arichmond · Accepted solution]

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.

[arichmond]

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)

[lbendlin]

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