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 making a custom visual in a dashboard connected to an Excel spreadsheet.
I just want to fetch distinct values from a column, but my values are always aggregated no matter which dataViewMapping type i use, and i don't want that.
For a column who contains (1, 1, 2, 2, 3, 3) i get [1, 2, 3] in my dataViews.
I want to get all the values keeping doubles.
For now here is my capabilites.json, simple as hell.
I already tryied other mapping types like categorical and others ...
Am i doing something wrong here ?
{
"dataRoles": [
{
"displayName": "Values",
"name": "values",
"kind": "GroupingOrMeasure"
}
],
"dataViewMappings": [
{
"table": {
"rows": {
"for": {
"in": "values"
}
}
}
}
]
}
I already tryied to modify "column values type" in "Request editor" pannel in PowerBI Desktop to differents values to get this "Don't summarize" option, but that does not affect the data i get.
Does someone knows how to do what i want ?
Thanks.
Based on my experience, you'll need to add an index column.
Hi,
I'm making a custom visual in a dashboard connected to an Excel spreadsheet.
I just want to fetch distinct values from a column, but my values are always aggregated no matter which dataViewMapping type i use, and i don't want that.
For a column who contains (1, 1, 2, 2, 3, 3) i get [1, 2, 3] in my dataViews.
I want to get all the values keeping doubles.
For now here is my capabilites.json, simple as hell.
I already tryied other mapping types like categorical and others ...
Am i doing something wrong here ?
{
"dataRoles": [
{
"displayName": "Values",
"name": "values",
"kind": "GroupingOrMeasure"
}
],
"dataViewMappings": [
{
"table": {
"rows": {
"for": {
"in": "values"
}
}
}
}
]
}
I already tryied to modify "column values type" in "Request editor" pannel in PowerBI Desktop to differents values to get this "Don't summarize" option, but that does not affect the data i get.
Does someone knows how to do what i want ?
Thanks.
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |