Getting multiple columns of quarters to single

[binayjethwa]

I have below issue where i need a quarter column but i have my data as below and its from excel and it cannot be changed from source. Is there any way we can do it in Power BI.

I have a quarter filter in my dashbord where user can select any quarter and he can see the data.  Thanks very much in advance

KPI	Unit	Q1 Target	Q1 Actual	Q2 Target	Q2 Actual	Q3 Target	Q3 Actual	Q4 Target	Q4 Actual
Operation Excellence	Progress	15	20
(ST)	%	16	21
(CC)	%	17	22
(SC)	%	18	23

Can we have it this way  using power bi?

KPI	Unit	Target	Actual	Quarter
Operation Excellence	Progress	15	20	Q1
Operation Excellence	Progress	20	21	Q2
Operation Excellence	Progress	21	21	Q3
Operation Excellence	Progress	22	22	Q4

[Idrissshatila]

Hello,

What you can do is to split this column in power query into two seperate columns and use them seperate.

https://support.microsoft.com/en-us/office/split-a-column-of-text-power-query-5282d425-6dd0-46ca-95b...

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[binayjethwa]

@Idrissshatila how many columns do i need to split and how will it create a separate column for Q1 , Q2 etc so i can select Q1 in slicer and i should see Q1 target and actual only . Since slicer take only 1 column in dropdown how can i specify which quarter it is. Since i need a slicer which has Q1 , Q2,...etc values in it and need to filter data based on that selection.

so if i select Q1 , i should see data of Q1(Actual, Target) only and so on. 

KPI	Unit	Q1 Target	Q1 Actual	Q2 Target	Q2 Actual	Q3 Target	Q3 Actual	Q4 Target	Q4       Actual
Excellence	Progress	15	20
(ST)	%	16	21
(CC)	%	17	22
(SC)	%	18	23

[Idrissshatila]

Hello,

Then you need to put the Quarter in the row section and the target actual in the values section.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[binayjethwa]

@Idrissshatila  There is no quarter column separately in my table. All i have is Q1 actual ,Q1 target, @Q2 actual, Q2 target etc as mentioned in above table.. and now i want to transform that table to below so i can use Quarter column in slicer and do slicing and dicing.

KPI	Unit	Target	Actual	Quarter
Operation Excellence	Progress	15	20	Q1
Operation Excellence	Progress	20	21	Q2
Operation Excellence	Progress	21	21	Q3
Operation Excellence	Progress	22	22	Q4