Default line chart Behavior

[Ahmad7886]

I am trying to make dashboard have a score card and a line with two other componenets, i am facing issue, if there is no selection of a country on wordcloud or on the map, the score card shows first value Argentina on card but the value underneath is the average value, and the line chart shows country name as Argentina and the line on the chart is the average of the data. how to handle this issue? why didnt score card and line chart shows the data of the Argentina?

here is the default behavior snapshot:

however the desired is:

[Anonymous · Accepted solution]

Hi @Ahmad7886 ,

Based on your description, the scorecard seems to show data for Argentina by default, but when no country/region is selected, the line graph displays the average instead of Argentina-specific data. There are several steps you can take to troubleshoot and resolve this inconsistency:

1. You can create a metric that you can use to check if a country/region is selected, and if it is not, it defaults to data for Argentina. Use this metric as a filter for scorecards and line charts to make sure they show the same data.
Here is an example of a DAX formula you might use:

SelectedCountry = IF(ISFILTERED('YourTable'[Country]), MAX('YourTable'[Country]), "Argentina")

2. Make sure the slicers are properly synchronised. When a selection is made on one slicer, it should be reflected on all other visual objects.
You can use the Edit Interactions feature in Power BI to manage how selections in one visual object affect other visual objects:

Use report themes in Power BI Desktop - Power BI | Microsoft Learn

3. Check if there are any default settings or filters applied to the line charts that may cause the line charts to show the average value instead of the data for a particular country/region.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.