Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |