Forum Discussion
Super UserData to be merged on Visual Level
Hi srlabhe ,
Thank you for your follow-up. The visual appearing blank in this scenario is expected and not an issue with Fabric or Power BI. This happens because the ChangeLabel measure uses SELECTEDVALUE from both the start and end date slicers. If either slicer doesn't have a single date selected, SELECTEDVALUE returns blank, making the measure blank for all rows and causing the table visual to appear empty. This only occurs after the measure is added.
To address this, use disconnected date tables for the start and end date slicers. If the slicers are connected to the main table, data is filtered out before the measure runs, preventing it from accurately determining if a record is new, deleted, modified, or unchanged between snapshots. Disconnected slicers keep the full dataset visible, allowing the measure to compare the two dates directly.
It's also important that the measure never returns blank. It should handle cases where one or both slicers aren't selected and return a meaningful value, so the visual stays visible. When both dates are selected, the measure can then determine the status of each ID. This approach keeps the table from disappearing.
If you want to let users filter by change type (like New or Modified), use a separate measure as a visual level filter instead of relying on the label measure alone. This way, the table remains populated even if no change type is selected.
Thank you.
Hi srlabhe ,
Thanks for reaching out to the Microsoft fabric community forum.
The behavior you're seeing is expected with the current slicer selections and setup. When the Start Date is set to an earlier snapshot and the End Date to a later one where some names or IDs are missing, those records are correctly marked as Deleted. This shows the ChangeLabel logic is working as intended, since it checks for each ID's presence across the two selected snapshot dates rather than merging the data.
As long as each slicer is in List mode with single select, the SnapshotDate column is of Date type, and the table visual includes the ID field for row context, your results are accurate. The solution meets both the original requirement and the follow-up scenario, so no further changes are needed unless you want to add more filtering or formatting.
Please find the attached PBIX and Screenshort file for your reference.
Best Regards,
Tejaswi.
Community Support
srlabheThanks but I want to use the change status column as slicer and being it as measure cant add in slicer. Any alternative for th esame?
Hi srlabhe ,
This is expected behavior in Power BI, as measures cannot be directly used in slicers. To work around this, you can create a small, disconnected table listing change statuses such as New, Deleted, Modify, and No Change, and use it as the slicer. The slicer selection is matched to each row's calculated change result using a filtering measure.Applying this measure as a visual filter allows the slicer to function correctly while keeping the change logic dynamic.
Thank you.- srlabhe
Yes but when I select multiple values form filter it deosnt work as required. For ex if I just want to show everything except No Chnage and select in filter accordingly it still shows "No change"data.Below is the measure i am using to select data
VAR selChange = SELECTEDVALUE( ChangeType[Change] ) // value selected in ChangeType slicerVAR rowChange = [varMeasRMAssignDiff] // the computed change label for the rowRETURNIF(ISBLANK(selChange) || ISBLANK(rowChange),1, // if no change selected or row has no label, keep it visibleIF(rowChange = selChange, 1, 0))