One Slicer Different table...

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.