Hi Guys, I have model like that: and In a model currently i have visuals filtered by Daily Amortized Costs . I am using top 5 filtered within line chart visuals. Total Amortized Cost coming now from Daily Fct table: How to switch easily this visual to use Total Cost for monthly table and filter visual by top 5 but from montly fct table? (i suppose it will be proper set up).Best,Jacek

Hi jaryszek , Thanks for reaching out to the Microsoft fabric community forum. You can address this by utilizing Field Parameters in Power BI, which enable dynamic switching between different fields or measures within a single visual. This approach is ideal for scenarios where you need to display data at varying granularities, such as daily or monthly. By including both your daily and monthly measures within one parameter, you can use it in your visual and add it as a slicer, allowing users to toggle between views without creating separate visuals. While Field Parameters do not automatically detect granularity, they offer a straightforward manual solution. If you require automatic adjustments when drilling through a hierarchy, consider creating a DAX measure with the ISINSCOPE function to modify calculations based on the visual’s context. For most situations, Field Parameters remain the most practical and flexible option. For step-by-step guidance, please refer to Microsoft’s documentation: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters Please find the attached PBIX and Screenshort file for your reference. Best Regards,Tejaswi.Community Support

Visual with different granularity how to switch?

Forum Discussion

Related content

Data Granularity

Handle AverageX on different granularities matrix drilldown

Average granularity

Calculate between different granularities

Modeling with different granularities