Forum Discussion
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
- Anonymous4 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
- AnonymousNot 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.