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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
NgaMoon
Frequent Visitor

Setting data fields is unique

Hello every one, 
NgaMoon_0-1709870857197.png

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"
},
],
1 ACCEPTED SOLUTION
Paulhaha
Helper I
Helper I

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

View solution in original post

3 REPLIES 3
dm-p
Super User
Super User

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





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)




Paulhaha
Helper I
Helper I

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

NgaMoon
Frequent Visitor

@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?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors