Forum Discussion

akim_no's avatar
akim_no
Helper III
1 year ago
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,...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi akim_no ,

    Up to 10 million rows it is generally manageable with good model design.
    Hope this clarifies!

johnt75's avatar
johnt75
Super User
1 year ago

To force the duplication of rows, one per week, you would need to include the week column or similar in the table / matrix values. You don't necessarily need to make it visible, you could set the column width to 0.

You can create a measure like

Row is visible =
VAR MinDate =
    MIN ( 'Date'[Date] )
VAR MaxDate =
    MAX ( 'Date'[Date] )
VAR BeginDate =
    SELECTEDVALUE ( 'Table'[BeginDate] )
VAR EndDate =
    SELECTEDVALUE ( 'Table'[EndDate] )
VAR Result =
    IF ( BeginDate <= MinDate && ( ISBLANK ( EndDate ) || EndDate >= MaxDate ), 1 )
RETURN
    Result

Add this as a filter to the table / matrix, set to show only when the value is 1