topic Re: Setting data fields is unique in Custom Visuals Development Discussion

Setting data fields is unique

Anonymous — Fri, 08 Mar 2024 04:21:06 GMT

Hello every one,

I have a small problem with my custom visuals that when I drag data into the visualizations box it can overlap, meaning I can drag "Profit" into both column and value, I want to set it to only be able to pulled into a single field. How can that be done? Below are the capabilities of Hope everyone can help

{

"dataRoles": [

{

"name": "columns",

"displayName": "Columns",

"displayNameKey": "Visual_Columns",

"kind": "Grouping"

{

"name": "values",

"displayName": "Values",

"displayNameKey": "Visual_Values",

"kind": "Measure"

Re: Setting data fields is unique

Anonymous — Mon, 11 Mar 2024 02:24:06 GMT

@lbendlin , Sorry for pinning you on this news, but can you tell me if there is a way for each data field to only be dragged and dropped into 1 visualizations field?

Re: Setting data fields is unique

Anonymous — Mon, 11 Mar 2024 09:14:20 GMT

Hi,

As seen in the documentation (i didn't read it all), I don't know if it exists a normal way to say "don't accept this field if it has already been added".

You can probably find a way to "hard-code" this but I don't think it's a good idea.

However, you can manage the Data Roles in the capabilities.json file to ensure the data you drag into your fields respect the data type (related to Power BI Data Types)

Capabilities and properties of Power BI visuals - Power BI | Microsoft Learn

Also, you can watch the others custom visual codes to get an idea about how you can manage your data roles:

Github Custom Visuals

By the way, I think the best way to develop your custom visual is not to make sure that the users won't be able to drag 2 or more times the same data, but to be sure that your data roles are well defined to prevent misunderstanding and avoid this case when the same data is dragged too much times

Have good day

Re: Setting data fields is unique

dm-p — Tue, 12 Mar 2024 13:40:03 GMT

This isn't currently possible. You can constrain fields by their data type (or column/measure type) in the dataRoles, but you can't prevent a user from adding the same column or measure multiple times to the data view.

Daniel