One Slicer Different table...

[Young_G_Han]

  Dear Kudos...

I have one slicer that selects Currency.

I would like to make 4 different graph that shows different exchange rate by selected currency.

For example,

if I select USD to EUR, AUD, GBP, JPY and CNY

I would like to show 4 different graphs show different graphs for each currency.

Alphabetic order is fine for me, so...

Graph 1. AUD

Graph 2. CNY

Graph 3. EUR

Graph 4. GBP

and JPY does not need to be shown.

Is there any possibility of showing graphs like this?

[devesh_gupta]

@Young_G_Han 

Yes, it's possible to create multiple graphs based on the selected currency using a slicer in Power BI. You can achieve this by creating separate visualizations for each currency and then using a slicer to filter the data accordingly. Here's how you can do it:

1. Load Your Data:

   • Import your data into Power BI. Make sure it includes columns for Date, Currency, and Exchange Rate.

2. Create Slicer:

   • In the "Fields" pane on the right, find the "Currency" field.
   • Drag and drop it onto the report canvas to create a slicer visual.

3. Create Four Different Visualizations:

   • Create four different visualizations (charts or tables) to display exchange rates for AUD, CNY, EUR, and GBP.
   • Use the "Date" and "Exchange Rate" fields in these visualizations.

4. Filter Visualizations Based on Slicer:

   • Select each visualization one by one.
   • Go to the "Visualizations" pane on the right.
   • Under the "Filters" section, drag and drop the "Currency" field.
   • Choose the currency you want to display for that specific visualization (e.g., AUD for the first visualization, CNY for the second, and so on).
   • Repeat this process for each of the four visualizations.

5. Arrange the Visualizations:

   • Arrange the four visualizations on your report canvas in the desired order (AUD, CNY, EUR, GBP).

6. Exclude JPY:

   • If you don't want to include JPY in any of the visualizations, you can filter it out by selecting each visualization and applying a filter to exclude JPY.

7. Test the Slicer:

   • Use the slicer to select different currencies, and observe how it updates the visualizations accordingly.

If you find this insightful, please provide a Kudo and accept this as a solution.

[Young_G_Han]

  Dear Devesh_gupta

Thank you for your kind advice.

Because I have over 10 currencies in my table and want to make a random selection to compare the changes in the exchange rate.

So I need a solution for randomized selection...

Can you please help?

[devesh_gupta]

@Young_G_Han You can follow step 2 of the above solution and create a slicer to randmoly select the currency that you want to convert. I think step 2 is doing this task for you and the four different graphs are showing the 4 currencies to which you want to see visualization.

[Young_G_Han]

Dear Devesh Gupta

Thank you.

Because the solution is required for users who don't have any idea about the BI. It must be automatically working.

anyways, thank you.