Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All
Thanks in advance to your help.
I have two fields as measured value. I want to show a single value on charts or tables based on the user. Example, if user A logged in, then i would like to show Actual_amount and if user B logged in, i want to show Blended_amount. Currently i have to create 2 different .pbi file which i have to maintain to show two different dataset. I would like to maintain one file only having able to display information based on user and role.
CALL_DATE | ACTUAL_AMOUNT | BLENDED_AMOUNT |
01-JAN-2020 | 100 | 80 |
02-JAN-2020 | 120 | 100 |
03-JAN-2020 | 150 | 130 |
Hi @dkrishnan,
If you literally have two users and one measure to worry about then you can write a measure that does a check on USERNAME, e.g.:
IF(
USERNAME() = "USERA", SUM(Data[ACTUAL_AMOUNT]),
SUM(Data[BLENDED_AMOUNT])
)
But this is not maintainable if more users or roles need to be taken into consideration. In which case, you should use row level security and some modelling changes to dynamically handle measures.
BI Elite has an awesome walkthrough on this and explains it better than I can in a forum post.
Good luck!
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi
Thanks for the input. I have a rough idea based on the video link you sent. I already implemented the selected measures. I will need to tag the roles and test them. Will keep you posted.
regards
deven
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
14 | |
4 | |
3 | |
3 | |
2 |