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 am having issues with my dataReductionAlgorithm. I have attached my capabilities.json code below.
I am working on a custom visual with 3 fields, one category and two measures. My issue is that the dataReductionAlgorithm only fires if I add ALL three field into the visual, then it limits the data table to 1 row. Until I add all 3 fields, the data table includes ALL data.
Any ideas?
"dataRoles": [
{
"displayName": "KPI Name",
"name": "category",
"kind": "Grouping"
},
{
"displayName": "KPI Value",
"name": "kpimeasure",
"kind": "Measure"
},
{
"displayName": "Target Value",
"name": "targetmeasure",
"kind": "Measure"
}
],
"dataViewMappings": [ {
"conditions": [
{
"category": { "max": 1},
"kpimeasure": { "max": 1},
"targetmeasure": { "max": 1}
}
],
"categorical": {
"categories": {
"for": { "in": "category" },
"dataReductionAlgorithm": { "top": {"count": 1} }
},
"values": {
"select": [
{ "bind": { "to": "kpimeasure" } },
{ "bind": { "to": "targetmeasure" } }
],
"dataReductionAlgorithm": { "top": {"count": 1} }
}
}
}
]
Solved! Go to Solution.
After some testing I suddenly got it to work, to be honest I don't know why.
"dataViewMappings": [ {
"conditions": [
{
"category": { "max": 1},
"kpimeasure": { "max": 1},
"targetmeasure": { "max": 1}
}
],
"categorical": {
"categories": {
"for": { "in": "category" },
"dataReductionAlgorithm": { "top": {"count": 1} }
},
"values": {
"select": [
{ "bind": { "to": "kpimeasure" } },
{ "bind": { "to": "targetmeasure" } }
],
"dataReductionAlgorithm": { "top": {"count": 1} }
}
}
}
]
After some testing I suddenly got it to work, to be honest I don't know why.
"dataViewMappings": [ {
"conditions": [
{
"category": { "max": 1},
"kpimeasure": { "max": 1},
"targetmeasure": { "max": 1}
}
],
"categorical": {
"categories": {
"for": { "in": "category" },
"dataReductionAlgorithm": { "top": {"count": 1} }
},
"values": {
"select": [
{ "bind": { "to": "kpimeasure" } },
{ "bind": { "to": "targetmeasure" } }
],
"dataReductionAlgorithm": { "top": {"count": 1} }
}
}
}
]
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |