Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Grouping problem with imported salesforce data

Hello, 

 

I am having trouble grouping individual fields on a visualization of mine and I believe it has something to do with how power bi is accessing my information from salesforce. When I right click on the fields I want to group, I don't have an option for a grouping button. I have not been able to get any of my DAX code to work with this data and I can't get the imported data to display in the power query editor. Is there a way I can group these data structures and is this due to how the data is being imported from Salesforce?

 

I've tried using this solution: Solved: Grouping visuals not working (no right-click menu) - Microsoft Power BI Community 

but I believe this is obsolete. 

 

 

How my modeling tab is shown: Can't access new column or new table buttons

 

Thanks, 

Ryan 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    On the rigthclick on the column that is used for your x-axis on the field chooser and click group then choose the groups you want. Then use the new field to set your x-axis.

     

    Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    On the rigthclick on the column that is used for your x-axis on the field chooser and click group then choose the groups you want. Then use the new field to set your x-axis.

     

    Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.