Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I want to group together categories into custom categories, as is shown in this link (https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning). But when I right-click on the visual, I'm unable to find this option.
I should also note that my data is connected via PowerBI datasets through an Alteryx connection. Could this be the reason why?
Thanks,
afk
You create the grouping using a calculated column in the field list under the table, not the visual itself. You then set the axis to this new calculated column.
MyGroup = // This is exactly what the grouping function does, but this gives you more control over logic SWITCH( TRUE(), [Col1] = "This" && [Col2] = "That", "ThisThat", // && is AND [Col1] = "That" || [Col2] = "This", "ThatThis", // || is OR "SomethingElse" // This is the value if no other conditions is met )
Thanks for your suggestion @jsh121988.
But I can't create calculated columns either, I can only create measures. Again, I think this may be due to the fact that the data is coming from a PowerBI dataset.
Will this work for measures as well?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |