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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DanielSH
Frequent Visitor

Dynamically define dropdown list in custom Power BI visual

Does anyone know how to dynamically define the elements of a drop down formatting option for a custom Power BI visual?

I want my users to upload some photos in Advanced Edit mode, and then be able to select these photos on the formatting pane.

 

In the below simple, hardcoded example, I can build up the object dynamically, but then when I select from the drop-down, that value is not showing up as the selected value once the drop-down is unselected. Here is my code:

 

capabilities.json:

"objects": {
        "dataPoint": {
            "properties": {
                "enum1": {
                    "type": {
                        "enumeration": []
                    }
                }
            }
        }
    }
 
In settings.ts I've created the formatting card, but I populate it in a custom function:
defineEnum1() {
        const enum1 = new formattingSettings.ItemDropdown({
            name: "enum1",
            displayName: "Enum1",
            value: { "displayName": "Val 1", "value": 1 },
            items: [
                { "displayName": "Val 1", "value": 1 },
                { "displayName": "Val 2", "value": 2 },
                { "displayName": "Val 3", "value": 3 }
            ]
        });

        this.dataPointCard.slices.push(enum1);
    }
 
I then call this function in my update() function. Also tried calling it in getFormattingModel(), but the results are the same.
The result is that the value of the drop-down is always the one I define in the code. (If I leave value as empty, it'll always be null.)
I _think_ the problem is that since selecting a value from the drop-down is considered a change, the defineEnum1() function is called as a result, and overwrites the selection in the drop-down. But I couldn't figure out a way to work around this, and I also couldn't find any source code on GitHub that achieves the same.
 
Any advice would be much appreciated.
1 ACCEPTED SOLUTION

These posts concerned replicating the features in core visuals, where properties can be assigned to selectors (e.g., the legend or measure values), known internally as 'containers.' This didn't fully work but has since been fixed. For the older formatting pane implementations, Power BI would generate them for you. It would work off the data view rather than the approach you're using (which I assume would use another persisted property).

 

I have an example of dynamic dropdown population in Deneb, which you can find here. It may help you confirm if you're on the right track. I guess you'd need to somehow pass in the list of values from your other property, and this could conceivably work.

 

Hopefully some of this is useful for you. Good luck!

 

Daniel





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

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

3 REPLIES 3
DanielSH
Frequent Visitor

@dm-p I saw some entries from 2020 when you were trying to do the same thing (I believe). Did you manage to find a solution using the latest API?

These posts concerned replicating the features in core visuals, where properties can be assigned to selectors (e.g., the legend or measure values), known internally as 'containers.' This didn't fully work but has since been fixed. For the older formatting pane implementations, Power BI would generate them for you. It would work off the data view rather than the approach you're using (which I assume would use another persisted property).

 

I have an example of dynamic dropdown population in Deneb, which you can find here. It may help you confirm if you're on the right track. I guess you'd need to somehow pass in the list of values from your other property, and this could conceivably work.

 

Hopefully some of this is useful for you. Good luck!

 

Daniel





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

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




DanielSH
Frequent Visitor

Thank you, @dm-p, after checking your code I was able to implement the same!

Much appreciated for your help, you rock!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.