Forum Discussion

absmiths's avatar
absmiths
Regular Visitor
8 years ago
Solved

What determines the column order of a table data view mapping?

In my capabilities.json, I have data roles defined like this:   "dataRoles": [ {"displayName": "Measured Depth", "name": "measuredDepth", "kind": "Grouping"}, {"displayName": "Is Planned", "name"...
Need Help
  • v-viig's avatar
    v-viig
    8 years ago

    Columns order depend on how you fill data-fields of your custom visual.

    Custom visual must use roles property to detemine what column is.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

v-viig's avatar
v-viig
Icon for Community Champion rankCommunity Champion
8 years ago

Columns order depend on how you fill data-fields of your custom visual.

Custom visual must use roles property to detemine what column is.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • absmiths's avatar
    absmiths
    Regular Visitor
    8 years ago

    Okay - not the answer I hoped for - but at least confirms my suspicion.  Perhaps this would be a good feature request since parsing column data and matching by name to the configured values will be a common activity (I would suspect).

    • v-viig's avatar
      v-viig
      Icon for Community Champion rankCommunity Champion
      8 years ago

      We'll consider this idea but it's pretty easy to implement by enumerating columns and checking role name.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-viig Can you give an example of how to use the 'roles' property to determine column? 

    • dm-p's avatar
      dm-p
      Icon for Super User rankSuper User
      7 years ago

      Hi Anonymous,

      We've recently discussed this here, and this helped out the person making the post. See if this works for you and we can discuss further as necessary.

      Good luck!

      Daniel

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        dm-p 

        Thanks for the link.   I am using a table this time. e.g. dataView.table...what's the syntax to get the corresponding columns if it is table?  Thanks.

         

        dm-p wrote:

        Hi Anonymous,

        We've recently discussed this here, and this helped out the person making the post. See if this works for you and we can discuss further as necessary.

        Good luck!

        Daniel