Forum Discussion
khubieb
8 years agoFrequent Visitor
table dataViewMappings columns order and show items with no data dependency on chronological order
I am trying to develop a custom visual (Kanban Board sort of visual) and facing below limitations or perhaps my lack of knowledge in the dataViewMapping and its customizations , the common between th...
v-chuncz-msft
8 years agoCommunity Support
DAX Studio can be used to capture queries, you may have a look.
khubieb
7 years agoFrequent Visitor
thanks for the hint, it provides a good insight into another topic, but the problem is not in preparing the dataset via DAX. the dataset is good, it is only the order of dragging fields into the visual generates different results, i assume the dataset should be resilient to the order of fields addition to visual.
what i did last is:
- in capabilities.json , I forced one column (the one i would like to have it seed for left joining other related data) to have min=1, hence users now can't add other fields before this one
- switched to categorical dataViewMapping , this way the order of categories are appearing the way user is ordering them in the categories list, but now after v2.1 of the API only one view is created "categorical", i had to change my data processing logic to cope with this, before v2.1 , table view was generated even if "categorical" dataviewmapping was used
thanks anyways