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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FabriceMorin
Regular Visitor

Power BI Template Report

Hello,

 

I follow several tutorial about Power BI, but I didn't find anything about the ability to create "Template Report"

I work for a compagny in renewable energy and we need a monthly report about solar power station activity

So in my "template" I would to  design it with :

  • Dynamic report name
  • Dynamic monthly period
  • Dynamic year period
  • Dynamic solar power station image
  • Dynamic technique information
    • max power 
    • number of structures,
    • number of inverter
    • number of conversion station
    • area (in ha)
  • Dynamic liste of issues rised during the month (with all descriptions)
  • Dynamic several availabilities (gross, contractor, wanted, gap) for the current month + the same ones for the previous months (starting from january of the current year)

 

After having designed my report I want to fill it according to these 3 input parameters :

  1. choose one of the solar power station (there is a table PowerStation with 12 differents stations)
  2. choose a month
  3. choose a year

 

After choose these input parameters, all the dynamics parameters will be filled according to the selection.

 

I don't want to create report for each values of the cartesian product :

PowerStation X month X Year

So for 2017 it will be 12 x 12 x 1 = 144 reports  (12 powerStations during 12 months and so on per year).

 

Before this was easy because we used the ReportingServices but IT manager want to change the technology by using PowerBI.

I don't know how to do that with Power BI.

 

Can you help me ?

 

Best Regards,

 

Fabrice

 

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@FabriceMorin,

 

You may add Slicers in Power BI and create appropriate measures.

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

Community Support Team _ Sam Zha
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

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@FabriceMorin,

 

You may add Slicers in Power BI and create appropriate measures.

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

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

Thank you for you answer.

I will try this solution

Many thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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