Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
RachelC
New Member

Data in table displaying value instead of label from Dynamics

Hi,

 

I have a field/column in Dynamics which has a option set and when I try and load the data from the option set, it displays the value not the label which I want

Please see below
In Power Bi:
Created a Parameter:

FieldParam: Leads Measure = {
    ("Campaign", NAMEOF('lead'[Campaign]), 0),
    ("Lead Source", NAMEOF('lead'[Lead Source]), 1),
    ("Industry", NAMEOF('lead'[industrycode]), 2),
    ("Use Case", NAMEOF('lead'[Use Case]), 3)

The Problem is the 'Campaign' - displays as the value instead of the label


Screenshot 2023-06-25 190812.png

In Dynamics the column which has the option field where I want to get the label not the value as you can see in the last photo.
Screenshot 2023-06-25 191038.pngScreenshot 2023-06-25 190935.png

0 REPLIES 0

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors