The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, I have a slicer that lists the training host. Most of the host sites are USA states, but there are some that are not. I'd like to attribute these non-states to a state (e.g., if 'Ascent', have the map show the state of 'Indiana').
Here's what the map looks like when I select the non-state, 'Ascent':
Here's what I want the map to look like:
I tried this DAX measure but seeking any revisions to it so that the map displays the assigned state. Thanks so much.
Unfortunately, the map still returns a blank US map and not the state of Indiana, even after correctly entering my table name and not getting any errors in red font.
Perhaps there a different way to go about this? Really appreciate the help.
Hi @jiexika24
Here's a revised version of your DAX measure that should help achieve your goal:
MapStateShown =
IF (
ISFILTERED('Table Name'[Host]),
SWITCH (
TRUE(),
SELECTEDVALUE('Table Name'[Host]) = "Ascent", "Indiana",
SELECTEDVALUE('Table Name'[Host]) = "National", "United States of America",
SELECTEDVALUE('Table Name'[Host])
),
BLANK()
)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |