Hey friends:
New to PowerBI custom visuals and my problem is this. I'm importing a CSV which each column being a set of data. I need the first column which identifies each value to be returned with the column I'm selecting so I can build a JSON object everytime I import a column. My current work around is to have the user always import the terms as the first item and then add on as they select the funds they want to see, but this is not viable. Any help on how I can always have the first column (terms) be returned in the same object as other columns (fundData) I'm adding would be greatly appreciated!!
My curreent capabilities.json:
{
"dataRoles": [
{
"displayName": "Terms",
"name": "terms",
"kind":"Grouping"
},
{
"displayName": "Fund Data",
"name": "fundData",
"kind": "Grouping"
}
],
"dataViewMappings": [
{
"conditions": [
{
"terms": {
"max": 1
}
}
],
"categorical": {
"categories": {
"select": [
{"for": {"in": "terms"}},
{"for": {"in": "fundData"}}
]
},
"values": {
"select": [
{"bind": {"to": "fundData"}}
]
}
}
}
]
}
