Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!!
Solved! Go to 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?
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
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.
@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?
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
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!
@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.
Proud to be a Super User!
Can you provide some sample data?
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.
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |