Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.