Slicer default behaviour - how to change / control it?

[Anonymous]

hi, 

want to create a interactive dashboard/report with multiple information like first in screen below, here I want to have four Card views but all four will interact Separately with selected country in above Slicer ( countries are almost all countries in the world ), how I can have this control on my dashboard / report? by default this should show data for 4 different countries, when user click on a country no matter only first one will replace. ( if it is possible user selects 4 countries and all relative data (rate) will show in below 4 Card views, then it will help a lot )

regards

[ERD]

Hi @Anonymous ,

Do you mean you need to be able to choose several elements in horizontal slicer?

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

[Anonymous]

I have one Demo app (screenshot below) want this type of behaviour (in red rectangle) , also want " default it shows all 4 Cards values for different Countries " 

regards

[v-kelly-msft]

Hi  @Anonymous ,

Do you want something as below:

Create 2 measures as below:

Measure = CALCULATE(SUM('Table'[value1]),ALL('Table'))

Measure 2 = IF(ISFILTERED('Table'[category]),SUM('Table'[value1]),'Table'[Measure])

Check my .pbix file attached.

If it is not what you need,pls provide some sample data with expected output.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

thanks @v-kelly-msft for your help, will definitely check it and give feedback here.

please note that I failed to upload my sample data file in another post, how i can do it.

my another post link: https://community.powerbi.com/t5/Desktop/DAX-formula-to-calculate-Change-in-last-5-years/td-p/187389...

regards

[v-kelly-msft]

Hi @Anonymous ，

You could upload your sample .pbix file to Google or other cloud Service and share us a pulic link.

Or could you provide an expected output based on below sample data?

date           country           dollar price

4/1/2013   Canada                 5.71234

4/7/2013   Canada                 5.56302

2/1/2014   Canada                 5.81234

5/6/2014   Canada                 5.79234

7/1/2015   Canada                 5.92234

8/4/2016   Canada                 5.96234

6/1/2017   Canada                 4.02234

4/1/2018   Canada                 4.12234

4/1/2013  Brazil                     3.71234

4/7/2013  Brazil                     3.56302

2/1/2014  Brazil                     2.81234

5/6/2014  Brazil                     2.79234

7/1/2015  Brazil                     1.92234

8/4/2016  Brazil                     2.11234

6/1/2017  Brazil                     2.02234

4/1/2018  Brazil                     1.84234

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@v-kelly-msft 

i am sorry if it create misunderstanding, i do not have sample .pbix file, to test what i have learned yet. i just have access to this on Power BI Server as app and have Excel file  to load data. :- Link to Excel File 

if you mean the .pbix file on which i am working now, then i can upload it too.

below screenshot showing this requirement ( %Change ), hope this may help:

regards

[v-kelly-msft]

Hi @Anonymous ，

Sorry but I'm still confused,what I need is something like below:

You provide some raw data,advise me your logic then show me your expected output,which would save time to solve your issue.

Is the screenshot you showed in the last reply what you need?It would be appreciated if you could upload the .pbix file on which you are working now,but remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

thanks for your passions to help me @v-kelly-msft  and very sorry to failed to clear the requirement yet.

it is just a sample to test employees in department what they have learned, data is dummy (but may be there is any coincidence).

i want to calculate %Change for Last 5 Years for each Country.

it should calculate data row-wise and have average of %Change in last 5 years.

a formula i found on powerbi.tips is here (the sample as on their web page), but don't know if it is right choice (as per my very little knowledge) and how to restrict data for 5 years.

% Change = 
DIVIDE(
 CALCULATE(
 SUM('Auto Production'[Production]), 
 FILTER('Auto Production','Auto Production'[Year]=MAX('Auto Production'[Year])
 )
 ), 
 CALCULATE(
 SUM('Auto Production'[Production]),
 FILTER('Auto Production','Auto Production'[Year]=MIN('Auto Production'[Year])))
,0) 
- 1

hope this will clear.

thanks again for your interest.

regards