Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
4 | |
4 | |
4 | |
3 |