topic Re: How can i use two table data source in one visual object? in Developer

How can i use two table data source in one visual object?

Anonymous — Tue, 12 May 2020 10:32:13 GMT

Need help!How can i use two table data source in one visual object?Code such as:

{ "dataRoles": [ { "displayName": "Category Data", "displayNameKey": "CategoryData", "name": "category", "kind": "Grouping" }, { "displayName": "Category Data2", "displayNameKey": "CategoryData2", "name": "category2", "kind": "Grouping" }, { "displayName": "Measure Data", "name": "measure", "kind": "Measure" }, { "displayName": "Measure Data2", "name": "measure2", "kind": "Measure" } ], "dataViewMappings": [ { "categorical": { "categories": { "select": [ { "bind": { "to": "category" } }, { "bind": { "to": "category2" } } ] }, "values": { "select": [ { "bind": { "to": "measure" } }, { "bind": { "to": "measure2" } } ] } } } ] }

But I found that in the visual object of the matrix, rows can use it(two table data source)...Why?

Re: How can i use two table data source in one visual object?

Greg_Deckler — Tue, 12 May 2020 12:15:36 GMT

Sorry, what exactly is that you posted?

Re: How can i use two table data source in one visual object?

dm-p — Tue, 12 May 2020 20:33:18 GMT

Hi @Anonymous, and welcome aboard!

We will need a little more to go on to assist you - if you haven't seen it, I'd suggest reading this welcome post to help you get your question answered more quickly; particularly as there's very little knowledge of custom visuals development in the community, and they can be incredibly open-ended in how to approach solving challenges involving them.

Going on what you've provided, I can supply a quick response in that Power BI visuals don't support multiple sources and you have to map your fields into a single dataViewMapping. Once this has been set up, you can manipulate this using code later on in your visual's logic, which could be an option for you, but it's going to depend on what you're looking to do.

If you are able to provide a use case for what you are trying to achieve, and ideally some sample data, we can see if we can assist you with how you might try to solve this particular challenge (if it's possible).

Many thanks,

Daniel