cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saranp780 Member
Member

How to assign the filter not exact match to manage role

I have a list of user like this.

 

UserCost
JVAS012000$
JVAS023500$
JVAS035500$
JVAS045000$
JVAS052000$
JVAS062500$
KVAS013200$
KVAS024400$
VVAS012900$
VVAS024000$
VVAS035500$

 

I want to set the filter to role management because I don't want to let people from other departments that I also share my report to see the cost at my department. My requirement is let the user see the only cost of their department such as "JVAS" can display only their cost disable to see "KA and VV" cost.

 

I have tried to put [User Name] = "JVAS"  but when I swap to view role nothing happens. How can I do?

 

Power bi filter.jpg

 

My license is Power BI Pro.

1 ACCEPTED SOLUTION

Accepted Solutions
Ross73312 Super Contributor
Super Contributor

Re: How to assign the filter not exact match to manage role

Right now your filter says that the entire cost code has to be "JVAS".  Instead you want to is only check the left 4 characters and see if they equal "JVAS"

 

https://docs.microsoft.com/en-us/dax/left-function-dax

 

Should be something like LEFT([YourColumn], 4) = "JVAS"


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


1 REPLY 1
Ross73312 Super Contributor
Super Contributor

Re: How to assign the filter not exact match to manage role

Right now your filter says that the entire cost code has to be "JVAS".  Instead you want to is only check the left 4 characters and see if they equal "JVAS"

 

https://docs.microsoft.com/en-us/dax/left-function-dax

 

Should be something like LEFT([YourColumn], 4) = "JVAS"


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 258 members 2,549 guests
Please welcome our newest community members: