Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've been given model like below(Pic 1) which enabled me to create a hierarchy in matrix using Names (titles) of each table like in pic 2 so i can expand and know what belongs to what. Hierarchy is working well and ID's are matching correctly.
Basically my problem is that i want to have second column (Values in matrix options) presenting 'State' attribute of each entity. State is a string. Is there any measure methods to do it? How should I approach this problem? Appending maybe? Rearrange model?
What do you think :)?
Thanks in advance!
Hi @Anonymous ,
Hi @Zvikovich ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @Anonymous ,
If one id match more then one parent_id?And if a parentid with more then one state?Also is it possible to place the state directly at the value position?
Could you pls share a sample data and expected output result(show in excel)?
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |