cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FabriceMorin Frequent Visitor
Frequent 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

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI Template Report

@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
Community Support Team
Community Support Team

Re: Power BI Template Report

@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

FabriceMorin Frequent Visitor
Frequent Visitor

Re: Power BI Template Report

Thank you for you answer.

I will try this solution

Many thanks

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors