Forum Discussion

kkanda's avatar
kkanda
Icon for Resolver II rankResolver II
6 years ago

Trying to plot previous year's data on the same chart

Hi All,  We have a dataset comprising of outage duration for a set of dates. A simplified sample table is given below: OutageDate Mins Equipment Circuit Weather 8/20/2020 235 Cross arm ...
Need Help
kkanda's avatar
kkanda
Icon for Resolver II rankResolver II
6 years ago

Thank you Allison, I have a DimDate file with me. Do I add it to the Relationship table and relate to the Table 1?

And the slicer for Date will be based on DimDate file?

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago
Yes, add the DimDate table to the same Power BI report. Create a relationship between DimDate table and the data you're using based on [Outage Date] and DimDate[Date]

Then put the DimDate[Date] in the slicer, in the DAX and in the visualization.