Forum Discussion
Solved
Object State Display Problem by Period in Power BI
I am working on a dynamic display of object states in Power BI based on a time logic, similar to snapshots taken at different periods (in this case, weeks). My source table contains, for each object,...
johnt75, I mean, is there another solution or a setting that would allow us to keep the row duplication and week distinction without having to explicitly add the measure and the week to every table or matrix visual? Otherwise, it becomes slow and cumbersome we’d have to manually add both the measure and the week to every new visual, which isn’t ideal.
No, you will need some additional table and corresponding measure to enable this. As there is only 1 row in the underlying data then only 1 row would be shown. You need some other dimension to generate the dates which you can then use to show multiple copies of the same row.
