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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
lieselot_ve
Frequent Visitor

formatting pane - dynamic dropdown - selected value

I try to create a custom visual which behaves likes a matrix and where we can add 1 or more measures in the Values part of the visual.  
In the format visual, I was able to add a Specific Column card with a dropdown which contains the measures placed in the Values part of my visual.

 

settings.ts

class SpecificColumnSettings extends FormattingSettingsCard {
   
    series = new formattingSettings.ItemDropdown({
        name: "series",
        displayName: "Series",
        items: [], // will be populated dynamically in visual.ts
        value: { value: "", displayName: "" }
        //value: undefined
       
    });
 
but how can we get the selected value of this dropdown in visual.ts (update())?  No matter what I try, it does not seem to remember the value selected.  Does anyone have a working example for this?
 
Kind regards,
 
Lieselot
2 REPLIES 2
lieselot_ve
Frequent Visitor

a working (small) example would be a great help because this const selectedSeries =
this.formattingSettings.specificColumn.series.value?.value; always return undefined in our case

 

 
BeaBF
Super User
Super User

@lieselot_ve Hi!

To read the selected value from a dynamic ItemDropdown in the format pane, make sure you first populate the formatting model in update() and then access the property from the settings model.

Example:

 

this.formattingSettings =
this.formattingSettingsService.populateFormattingSettingsModel(
VisualSettingsModel,
options.dataViews?.[0]
);

const selectedSeries =
this.formattingSettings.specificColumn.series.value?.value;
 

If the dropdown keeps “forgetting” the selection, the usual causes are:

  • object/property names don’t exactly match capabilities.json
  • dropdown items are rebuilt without preserving the previous value
  • the selected value isn’t a stable key (use something like queryName, not display text)

Using a stable internal value and restoring it when repopulating the items typically fixes the issue.

BBF


💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Community News image 1920X1080.png

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors