Help in POwer BI report

[piyushjh]

Hi ,

I have 2 columns , 1 columns contains the attributes while the other column contains the value, I want to create a report with a filter of month which is one of the attribute in column 1

I want to create a report that pick the name and Month from column 1 and Previous Sales value from COlumn 2

Please see belwo the table

Column 1	Column2
Name 1	Null
Month 1	Null
Previous sale	Value
Name 2	Null
Month 2	Null
Previous sale	Value

[serpiva64]

Hi,

in power query:

- select colum2

- use fill up

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[piyushjh]

Hi,

Thank You for the response,I dont want the rows to be filled , I just want them to show in report with Month row as the filter any idea how to do this .

[serpiva64 · Accepted solution]

Hi,

if you, starting from this

want to get something like this 

take a look at the attached file

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !