cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rossenblok Frequent Visitor
Frequent Visitor

report selection on period

Hi, 

I have a table with 12 columns for every month (contains euro values, for example turnovers per custormer).

I want to select a period in my report (also for users), so that my visualisations will change with my selection.

How can I realize this in my report?

 

Ronny

 

1 ACCEPTED SOLUTION

Accepted Solutions
majdkaid22 Member
Member

Re: report selection on period

@rossenblok  you can pivot/unpivot in the power query of the dataset

5 REPLIES 5
Super User
Super User

Re: report selection on period

Hi @rossenblok,

If you have a column for each month you should unpivot the columns and you would get only 2 columns one with values and a other with month the. Use the month column to create a slicer for the selection.

Regards,
MFelix


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

Proud to be a Datanaut!




rossenblok Frequent Visitor
Frequent Visitor

Re: report selection on period

thx. 

do you mean unpivot in the dataset?

or is there a possibility to unpivot the table in powerbi itself?

majdkaid22 Member
Member

Re: report selection on period

@rossenblok  you can pivot/unpivot in the power query of the dataset

rossenblok Frequent Visitor
Frequent Visitor

Re: report selection on period

Cam you tell me how to do that?
Super User
Super User

Re: report selection on period

Hi @rossenblok ,

 

Check the tutorial below from RADACAD with the full detailed explanation on how to achieve this.

 

Pivot and Unpivot with Power BI (RADACAD)

 

Regards,

MFelix



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

Proud to be a Datanaut!




Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 146 members 2,537 guests
Please welcome our newest community members: