cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
twister8889
Helper V
Helper V

Create blank column to divide values into matrix table

Hi guys, 

 

I have a dataset that contains, current values (past and present month) and the forecast month, these information are divided by a column flag Current/Future. I created two matrix tables, and for each, I choose a flag Current/Future, but I would like just one table, and insert a blank column to divide the values Current and Future, it's possible?

This is my

ProductMonthCurrent/FutureValues
Aago110
Bago15
Cago12
Dago14
Aset12
Bset14
Cset15
Dset16
Aout250
Bout260
Cout245
Dout220


Expected result: Insert the blank column to separate Current and futere values.

Productago set out
A102 50
B54 60
C25 45
D46 20
1 ACCEPTED SOLUTION

Hi @twister8889 ,

I updated my sample pbix file(see attachment), please check whether that is what you want.

1. Pivot: use the names in column "Month" to create new columns (Values: Values column) in Power Query Editor

yingyinr_0-1632905837883.png

2. Add custom column in Power Query Editor

yingyinr_1-1632905880641.png

3. Create visual as shown in the below screenshot

yingyinr_2-1632906131381.png

Best Regards

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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@twister8889 , Not very clear .

 

A new column

 

COlumn = "/"

 

or

 

Column = blank()

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

First of all, thank you for your answer..

 

I have a measure for example Sum(Values), for month columns (Aug, September) with the flag 1 and the same measure for october is 2.
So, I would like to insert the blank column between end flags with value 1 and begin
flag value 2

Hi @twister8889 ,

I created a sample pbix file(see attachment), please check whether that is what you want.

yingyinr_1-1631760093212.png

If the above one is not your expected result, please provide more details(include calculation logic and expected result with screenshot) on your requirement. Thank you.

Best Regards

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

First of all, thank you for your answer..

Hi @yingyinr 

 

I need to have just one column with logical to Current and Future Values, and I need to put one blank column to separate Current and Futures Values, like the image belowBlank column.png

Hi @twister8889 ,

I updated my sample pbix file(see attachment), please check whether that is what you want.

1. Pivot: use the names in column "Month" to create new columns (Values: Values column) in Power Query Editor

yingyinr_0-1632905837883.png

2. Add custom column in Power Query Editor

yingyinr_1-1632905880641.png

3. Create visual as shown in the below screenshot

yingyinr_2-1632906131381.png

Best Regards

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.