Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I'm creating a custom Power BI Visual, and I would like to make use of the multiple data views as I don't want to duplicate data coming in and it would be much simpler. But I'm unable to get multiple data views as I always get 1 from the VisualUpdateOptions.
Here is my dataViewMappings config, I'd like to use a table for my dimensions and measures, and then a single for a single value coming in. But this is not working as expected.
"dataRoles": [
{
"displayName": "Dimensions",
"name": "category",
"kind": "Grouping"
},
{
"displayName": "Measures",
"name": "measure",
"kind": "Measure"
},
{
"displayName": "Server User ID",
"displayNameKey": "@LICENSEDUSER",
"name": "username",
"kind": "Measure"
}
],
"dataViewMappings": [
{
"conditions": [
{
"category": {
"max": 20
},
"measure": {
"max": 20
}
}
],
"table": {
"rows": {
"select": [
{
"for": {
"in": "category"
}
},
{
"for": {
"in": "measure"
}
}
],
"dataReductionAlgorithm": {
"top": {
"count": 50000
}
}
}
}
},
{
"conditions": [
{
"username": {
"max": 1
}
}
],
"single": {
"role": "username"
}
}
]
I did check the documentation and it mentions that multiple data views is possible:
Can anyone help or explain why this is not working for me?
HI @FoXTiSiTY,
You can take a look at following links if they suitable for your requirement:
Understand data view mapping in Power BI visuals - Power BI | Microsoft Learn
Objects and properties of Power BI visuals - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi @Anonymous,
I've gone through all the documentation. As explained in my original post, the documentation states that this is possible, i've also given an example of my capabilities file, but it just doesn't want to work.
Hi @FoXTiSiTY ,
Were you able to find a solution for the multiple dataViewMappings? I also need that functionality for my custom visual: I'm trying to make a custom visual that has both Cards and a Line Area Chart. Although the documentation noted that combining the single dataViewMapping with anything else was not possible, my visual still doesn't work, and I've tried different permutations: two separate categorical mappings for the cards, table and categorical, matrix and table, and even single and categorical out of desperation. However, nothing works.
Alternatively, do you know if there's a way to store the original unaltered, unfiltered source data as a dataView?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
4 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |