Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sraj
Responsive Resident
Responsive Resident

MAP VISUAL and slicer

Good Morning,

 

I have one DL attached to several accounts for example DL2222222 has Acct V002, V064, V789 and V1000.  Is there anyway to present this other than using the Drivers licence slicer?  I am also trying to use the map visual on this report to show how accounts are attached to this one DL. I am not sure if this is possible, please advise.

 

Thank you!!

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@sraj  Your question is still a bit confusing, are you just trying to find which DL have more than one account? 

 

You could create a table with DL and Count of Account number, this will highlight which DLs have the most accounts. Not sure if that's what you're after?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

8 REPLIES 8
v-rzhou-msft
Community Support
Community Support

Hi @sraj 

If you want to show value by account name, you can build dynamic RLS in power bi desktop.

Then if you publish your report on service, you can restrict the user to see value by their UserPrincipalName.

Build a user table, and relate to Data table by Account column.

User Table:

1.png

Data Table:

2.png

Click Manage Roles in Modeling, create a new role and add this measure:

[Drivers Licence] = 
CALCULATE (
    MAX(Data[Drivers Licence]),
    FILTER (
        User,
        User[UserName] = USERPRINCIPALNAME()
            && User[Account] = Data[Account]
    )
) 

 Let's have a test.

If I am V001, I can see DL87656777

3.png

For more info you may refer to this blog: Dynamic Row Level Security with Power BI Made Simple

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

AllisonKennedy
Super User
Super User

@sraj  Your question is still a bit confusing, are you just trying to find which DL have more than one account? 

 

You could create a table with DL and Count of Account number, this will highlight which DLs have the most accounts. Not sure if that's what you're after?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

sraj
Responsive Resident
Responsive Resident

Location is sorted, I just wanted to see if there is any other way to look for DL attached to several accounts without using a DL slicer.

 

Thanks!

negi007
Community Champion
Community Champion

@sraj to have the map visual you need to have some location data in your dataset. Location data could be zipcode, geo-cordinates like latitude and longitude etc. 

 

also slicer that you wish to use depend on what you have in your dataset and how the dataset is structure.




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



Proud to be a Super User!


Follow me on linkedin

littlemojopuppy
Community Champion
Community Champion

Can you provide some sample data?

Capture.PNG

@sraj , You need to have location /pin code, Lot-Long/City/State/country data to have a MAP.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
sraj
Responsive Resident
Responsive Resident

Yes, Location is sorted. I just wanted to see if there is any other way to look for DL attached to several accounts without using a DL slicer.

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.