cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Add new columns separately yo Matrix Table

Hi,

 

I am trying to add new columns into the MATRIX table below;

 

This is the table i do have currently;

 

Table.JPG

 

 

 

 

This is all working fine, now i want to add several new columns to this Matrix. Please see below what i am looking for; (For Example 2 columns below but there 7-10 columns i will add)

 

Table.JPG

As you can see above "Number of Settlement" and "Number of Warning" are totally speparate Columns which has nothing to do with ROW and COLUMN headers (Left Side).

 

I am looking for count of certain cases based on different scenario.

 

Any suggestion would be appreciated

 

I tried with MATRIX and ACETRYS MATRIX LIGHT tables but its not working because whenever I add new columns it usually come inside column header which i dont want. New column must be seperate.

 

Thanks

5 REPLIES 5
Highlighted
Super User VII
Super User VII

Re: Add new columns separately yo Matrix Table

@damit23183 there is a workaround for this, see attached and you will get an idea, look at the matrix with the blue background, you need to apply the similar logic.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Microsoft
Microsoft

Re: Add new columns separately yo Matrix Table

Hi,

 

Yes I went through it which i already have that is total of each row but, I would like to add new columns which has nothing to do with current and lastyear values. If you take your example then ALL Total / Grand Total column is sum of rows and columns value.

 

If you take your example then I would like to add two new columns into the existing Matrix; 

 

1) No of products where date is not Null = NOPWON

2) No of Products where date is null = NOPWN

 

This is just an example;

 

Your example should look like below; this is an example from EXCEL but this is what i am looking for.

 

Table.JPG

 

 

Thanks

Highlighted
Super User VII
Super User VII

Re: Add new columns separately yo Matrix Table

@damit23183 idea is in the solution I pasted, you have to tweak it as per your needs, you can control whatever you want.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Microsoft
Microsoft

Re: Add new columns separately yo Matrix Table

Hi,

 

Thanks for quick turn around.

 

My apologies, didn't look at Measure that you have created with variable. 

 

Thought to be direct solution but i will look into that MEASURE and see how it work. 

 

Thanks a lot for your suggestion.

 

Thanks

Highlighted
Super User VII
Super User VII

Re: Add new columns separately yo Matrix Table

@damit23183  as I mentioned, it is not out of the box, you have to create workaround as shown in shared in pbix. good luck.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors