Forum Discussion
How to add a column in your matrix
Hi, shbz1690
Thank you for your feedback.
I did this by using Tabular Editor in Power BI.
I was thinking about how to show it like what you described on the post, but I could only find this way to do it. I think there are many other ways to achieve this but in my case, I could do it in this way only.
First, download the external tool (Tabular Editor) for Power BI, and install it.
In Tabular Editor,
- create a calculation group
- under the calculation group, create calculation items
item1: Sedan
item2: Coupe
item3: Sport
item4: OneMoreColumn
item5: Total
I wrote the DAX measure for each calculation item. Keep in mind that the Total also has to be created.
I could not find a way to draw pictures for each step.
If you are OK, I can show it to you via TEAMS meeting.
Thank you very much.
Super UserHi, shbz1690
Please correct me if I wrongly understood your question.
Please check whether the below picture is what you are looking for.
I have created a Calculation group by using Tabular Editor in Power BI, and add this Calculation Group-Column to the Column-section in matrix visualization.
The link to the sample pbix file is down below.
https://www.dropbox.com/s/7jgpbcnwcsyavxo/shbz1690.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
What you did is correct, can you please let me know the steps so that I can do it in my power BI file.
- Jihwan_Kim
Hi, shbz1690
Thank you for your feedback.
I did this by using Tabular Editor in Power BI.
I was thinking about how to show it like what you described on the post, but I could only find this way to do it. I think there are many other ways to achieve this but in my case, I could do it in this way only.
First, download the external tool (Tabular Editor) for Power BI, and install it.
In Tabular Editor,
- create a calculation group
- under the calculation group, create calculation items
item1: Sedan
item2: Coupe
item3: Sport
item4: OneMoreColumn
item5: Total
I wrote the DAX measure for each calculation item. Keep in mind that the Total also has to be created.
I could not find a way to draw pictures for each step.
If you are OK, I can show it to you via TEAMS meeting.
Thank you very much.
I was able to replicate it, thanks. The only issue with this solution is I can't see the underlying data when I right click on any item. Earlier it was showing SHow Data Point as Table which isn't available anymore. But thanks a lot for solution.