Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi everyone,
I am new to PowerBi and have quick question. I want to create new collumn called 'country' that would allow me to put it into slicer and when I select specific country it will update the chart accordingly. So for example: if I select Austria from slicer the chart will automatically show values from AT.Buil. Later on I will add more categories and charts like AT.Service, AT.Retail, etc and ultimately I want that whenever I select any of the countries all charts will show the values on charts. If you have suggestions how to go around this problem and make it more effective, I would highly appreciate that. Thank you.
Solved! Go to Solution.
Hi @Anonymous
You may try to use SELECTEDVALUE Function and SWITCH Function to create the measure as requested. For example:
Value = SWITCH ( SELECTEDVALUE ( Country[Country] ), "a", CALCULATE ( SUM ( Table[AT.BUIL] ) ), "b", CALCULATE ( SUM ( Table[AT.BUIL2] ) ) )
Regards,
Cherie
Hi @Anonymous
You may try to use SELECTEDVALUE Function and SWITCH Function to create the measure as requested. For example:
Value = SWITCH ( SELECTEDVALUE ( Country[Country] ), "a", CALCULATE ( SUM ( Table[AT.BUIL] ) ), "b", CALCULATE ( SUM ( Table[AT.BUIL2] ) ) )
Regards,
Cherie
Thank you mate you are a legend. Also, one more if you or anyone could help me with. Have same dates tables across different categories and I want to add all of those dates into one measure so I could add to slicer and then update all sentiment charts similarly as I do with countries. I have tried to use same method but no luck so far. Any advice?
Thanks in advance
Hi @Anonymous
It seems you may try to create a calendar table with date column and link it with other tables. Then use the date column as slicer. You may have a look at below article about relationship.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Regards,
Cherie
Hi Cherie,
I was thinking about creating relationship between dates, however since I linked data from a excel file that is on my onedrive, all the manage relationship buttons are greyed out in pbi desktop. So either have to find a work around or go to the initial excel file and try to do change there.
I would appreciate any advice on that.
Regards,
Arnold
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!