Forum Discussion
Different Matrix visuals on multiple reports using 1 FACT table arranged in key value pairs
Hi Riyaz999 , Thank you for reaching out to the Microsoft Community Forum.
The bar chart showed repeated stations because Power BI was pulling all records from the fact table instead of just the latest value for each station at noon. It wasn’t filtering down to a single record per station, so multiple entries appeared in the visual.
We fixed this by adjusting the measure logic to dynamically filter the fact table for the latest date per station and for 12:00 PM, ensuring only one value per station appears in the bar chart. To support your dynamic metric selection, we also added a FWDMetricSlicer table that works with a SWITCH-based measure. This lets the chart update automatically based on whichever metric you pick in the slicer.
Please see the attached .pbix file for your reference.
If I wanted to attach a sample Power BI file, how would I do that?
This is what my reports look like using two calculated metric tables namely FilteredReportMetricNoonFW and FilteredReportMetricHrlyPrecip where I have hard coded the following in each respective table:
'ReportMetric'[ReportId] = 1
'ReportMetric'[ReportId] = 3
where I would want a single table with the above line reading as follows:
'ReportMetric'[ReportId] = _ReportId
and then there would only be a single table for filtering report metrics.