Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago

Paginated report working PB dataset

I have been given a PB dataset to build a report on. DAX is not my strongest skill, so I am having difficulties pulling data into report's datasets. For example, I have a date column. I need to pul...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Markzolotoy 

 

When creating the dataset in Paginated reports, you can use the GUI to put in the fields you want and then use the parameters at the top to define which parameters you want to use.

 

I would suggest asking the person who created the dataset to create a column in the date table which has got the last 90 days. You can then use the column in your parameters to automatically select the past 90 days.

 

Here is a tutorial on how to possibly do this: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs