Forum Discussion
Single select slicer
I have a table called *Dim_Country with only country names.
Then I have another table Global Data with all data including Region , Country name and values of total consumption.On the page I have slicer, single select which selects one country for example France and shows all data related to France on every chart.
I want to show where France is in relation to other countries in the same region, Europe, based on the Consumption. SO I want to have all counties in Europe including France. This is the only chart that shows any other countries.
I have a table called *Dim_Country with only country names.
Then I have another table Global Data with all data including Region , Country name and values of total consumption.
On the page I have slicer, single select which selects one country for example France and shows all data related to France on every chart.
I want to show where France is in relation to other countries in the same region, Europe, based on the Consumption. SO I want to have all counties in Europe including France. This is the only chart that shows any other countries.
Hi Ania26 ,
The problem that you have is related with the way you setup your chart, since you want to show information at the country level and you are using the slicer on country level the visual will never show any other countries except the one that is selected.
To have this working you need to go for the solution that cengizhanarslan refer to have second table however in my opinion this table is not used for the select but for the axis on the chart that will allow you to get the correct value:
Total Sales Group =
VAR SalesGroup = SELECTEDVALUE('Sales Territory'[Group])
Return
CALCULATE(
[Total Sales],
'Sales Territory'[Name] = SELECTEDVALUE('Sales Territory Filter'[Name])
&& SELECTEDVALUE('Sales Territory Filter'[Group]) = SalesGroup
)Be aware that you may need to get the SalesGroup from the fact table,
In this case I have created a Sales Territory Filter that is a replica of the dimension I use for country.
The Slicer is gettign information from the dimension table and then on the bar chart I'm using the disconnected table to get the countries that way I keep a single slicer and that specific chart works has intended.
Thank you for help.