Forum Discussion
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 :
- choose one of the solar power station (there is a table PowerStation with 12 differents stations)
- choose a month
- 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
You may add Slicers in Power BI and create appropriate measures.
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
2 Replies
- v-chuncz-msftCommunity Support
You may add Slicers in Power BI and create appropriate measures.
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
- FabriceMorinRegular Visitor
Thank you for you answer.
I will try this solution
Many thanks