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,
I’m new to this forum and would appreciate your help. I’ve built a report with a shape map, a dropdown slicer and several cards.
The slicer allows to select a year and pressing a state shows values in cards.
I only have one table which has all the information I need to show in the cards.
Among many other columns and rows, my table is basically as follows:
When I select a State, everything works fine (since they all appear on the shape map), but things aren't working when I click outside the area of States. I would like data returned for COUNTRY in cards when no state is selected. In other words to show as default values. I know I must apply some advanced filter but have no idea how to do it.
Thanks
Solved! Go to Solution.
Hi @ero,
I made one sample for your reference.
We can create a measure as below to work on it.
Measure = var _Catoosa = CALCULATE(SUM(Sheet1[Total]),FILTER(Sheet1,Sheet1[_State]= "Catoosa")) return IF(ISFILTERED(Sheet1[_State]),CALCULATE(SUM(Sheet1[Total])),_Catoosa)
Regards,
Frank
My approach to formating numbers in the card was all wrong. When using measures to fill a card, one must select the measure in the fields pane, and then go to format in visual tools and choose the format. Its quiete simple yet took me a while to find out. Hope this will help others.
Hi @ero,
I made one sample for your reference.
We can create a measure as below to work on it.
Measure = var _Catoosa = CALCULATE(SUM(Sheet1[Total]),FILTER(Sheet1,Sheet1[_State]= "Catoosa")) return IF(ISFILTERED(Sheet1[_State]),CALCULATE(SUM(Sheet1[Total])),_Catoosa)
Regards,
Frank
Worked fine, except need to format results . I tried severall combinations with Format function #,##0 but keep getting an error message. Any ideas?
Thanks
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |