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 everyone,
I wonder if someone could clarify for me please. I am using PowerBi to report on some Dynamics data. On a quote entity in dynamics, you have the status e.g Draft, Active, Closed etc.
In my quote entity table, the status is held as the code but in my BI Visuals, the code of course means nothing to end users viewing the data. Is there any way to resolve the code group to the description? Having a chart with headings of 0, 1, 2 etc is meaningless.
Thanks
Solved! Go to Solution.
Hi, you can have a dim table to the screenshot you put, 2 columns, one is the code, the other is the Status. Create relationship with your dynamic table, and write DAX to display status instead of code. Or add a calculated column to display the Status, up to you.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |