Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rossenblok
Regular 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

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

View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

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

Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



thx. 

do you mean unpivot in the dataset?

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

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

Cam you tell me how to do that?

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.