Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi
I have an Employee dimension with 2 rows:
ID Name Value
id1 "Mr Anderson 1"
id2 "Mr Anderson 2"
If I show this in a table visual without including the ugly id column, it will display
Mr Anderson 3
But that is of course not what I want- I want to display the same name twice
In Reporting Service, SSAS and every other report-tool know to man, you can define a "key Column" and a "Label Column", for each dimension property, so that you may choose how to handle a situation like this.
Please tell me this is possible in Power Bi also!
Solved! Go to Solution.
@RootOfMinusOne , You need to use the ID(unique column in visual) , or you can try value as not summarized (if they are different)
This is what I figured but I cannot belive such an important feature has not been implemented. The real ID is very long and the user does not care about it at all- and "value as not summarized" will only work in the simplest of cases.
@RootOfMinusOne , You need to use the ID(unique column in visual) , or you can try value as not summarized (if they are different)