Forum Discussion

NimaiAhluwalia's avatar
NimaiAhluwalia
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

2 Calanders in 1 report - Solution

Hello Community   I wanted to get any ideas for the two problems which I am having,   Problem 1 - I have a report which was previously having normal calander but now the customer wants me to impl...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • johnt75's avatar
    johnt75
    1 year ago

    For your first problem you could use a field parameter. Add the appropriate columns to the field parameter and use the field parameter in your visuals, then a slicer will allow the user to pick which they want to see.

    For your second problem, you can't do it in Power BI desktop. Calculated tables are only calculated during data refresh, they don't take into account any filters or slicers you may put in the report.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

For your first problem you could use a field parameter. Add the appropriate columns to the field parameter and use the field parameter in your visuals, then a slicer will allow the user to pick which they want to see.

For your second problem, you can't do it in Power BI desktop. Calculated tables are only calculated during data refresh, they don't take into account any filters or slicers you may put in the report.