The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)