Hi @manojk_pbi ,
Thanks for reaching out to the Microsoft fabric community forum.
Trend chart behaves differently from the others when a single month is selected. Specifically, the trend chart reduces to a single column, which isn't the desired behavior.
Here are a few approaches to handle this:
1. Adjusting the Data Logic for the Trend Chart:
Always Show a Range: Modify the trend chart's data query to always pull data for a range of months, even if a single month is selected. For example, if you select January 2025, the chart could default to showing data from December 2024 to February 2025.
Dynamic Data Window: Implement a dynamic window that adjusts based on the selection. For instance, if the selection is a single month, expand the view to include the adjacent months.
2. Using Conditional Logic in the Chart Settings:
Custom Filter Logic: In tools like Power BI or Tableau, you can create conditional filters. For example: If the selection is for a single month, ignore the filter for the trend chart. If multiple months are selected, apply the filter normally.
3. Implementing DAX (This logic checks if a single month is selected and adjusts the data accordingly)
Trend Data =
IF(
HASONEVALUE(Date[Month]),
CALCULATE(SUM(Costs[Amount]), DATEADD(Date[Date], -1, MONTH), DATEADD(Date[Date], 1, MONTH)),
SUM(Costs[Amount])
)
Use the newly created measure in your trend chart. This will ensure that the trend chart displays the data for all months, regardless of the filter applied.
4. Using a Slicer for the Trend Chart:
Separate Slicer: Use a dedicated slicer for the trend chart that doesn’t respond to the main page slicers. This way, you control what data the trend chart displays independently.
5. Adjust Visual Interactions: You can also adjust the interactions between visuals to ensure that the trend chart does not respond to the slicer or filter selections. Here’s how you can do it:
-->Select the trend chart.
-->Go to the "Format" pane.
-->Under "Edit interactions," choose the "None" option for the slicer or filter visuals that should not affect the trend chart.
Please refer Microsoft official document.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
