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.
Hi I'm creating a custom visual and have used the standard table dataViewMapping
"dataViewMappings": [
{
"table": {
"rows": {
"select": [
{
"for": {
"in": "category"
}
},
{
"for": {
"in": "measure"
}
}
]
}
}
}
],
It parses the results just fine.
"table":{
"columns": [
{
"roles": {...},
"type": {...},
"format": undefined,
"displayName": "Category",
"queryName": "Product.Category",
"expr": {...},
"rolesIndex": {...},
"index": 0,
"identityExprs": [..]
},
{
"roles": {...},
"type": {...},
"format": "#,0.00",
"displayName": "Measure1",
"queryName": "Avg(Sales.Unit Price)",
"expr": {...},
"rolesIndex": {...},
"index": 1,
"isMeasure": true,
"aggregates": [..]
},
{
"roles": {...},
"type": {...},
"format": "#,0.00",
"displayName": "Measure2",
"queryName": "Sum(Sales.Sales)",
"expr": {...},
"sort": 1,
"sortOrder": 0,
"rolesIndex": {...},
"index": 2,
"isMeasure": true,
"aggregates": [...]
}
],
"identity": [...],
"identityFields": [...],
"rows": [...]
}
However I want to know the order in which the Measures are listed by the user in "Measure Data". If you look at a normal table, the columns get switched when you swap the order in the Data Fields Pane.
I don't see that change happening in the DataView.
How can I check what the order is of the measures?
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 |