MAP VISUAL and slicer

[sraj]

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!!

[Anonymous]

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:

Data Table:

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

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 · Accepted solution]

@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?

[sraj]

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]

@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.

[littlemojopuppy]

Can you provide some sample data?

[sraj]

[amitchandak]

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

[sraj]

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.