Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have sales data at different LEVELS in 2 different tables.
Example: STATE level data in FCT_STATE and CITY level data in FCT_CITY table.
My requirement:
Add 2 slicers STATE and CITY with only one LINE CHART. when a user selects STATE slicer,chart should show data from FCT_STATE table and when user selects CITY slicer , same chart should pull data from FCT_CITY table.
is this possible?
thanks
Yes, the specifics however are going to vary depending on your exact scenario. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
Details, like whether or not you have a relationship between the tables, matter. Now, that being said, the first thing you will need is a way to determine if State or City is filtered essentially. You could use something like ISFILTERED. See attached simple example and hopefully it will get you there (Page 3). If not, try to add some specifics to your request. Another potential solution is through the use of bookmarks, but as I said, depends on your particular details.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |