Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Rena
Resolver II
Resolver II

Error on a Switch Function that makes no sense

So I have a Switch Function that builds a display box.

Rena_0-1767022810601.png

It makes this:

Rena_1-1767022834692.png

 

The problem is that I want to change the words in Row 5 to "Total # Tagged DT Events".  Sounds simple.  I change the measure to this:

Rena_2-1767022889980.png

But my table deletes the value rather than adding the word "tagged":

Rena_3-1767022926845.png

 

 

1 ACCEPTED SOLUTION
Rena
Resolver II
Resolver II

Never mind.  The answer was in the question itself.  It is a switch true.  When I change the word, the value was deleting because the words no longer matched my table.  It has been too long since I created that, I didn't realize it was looking at a table and giving a value based on if it matched the table.  I had to go into Transform Data and edit the table that was originally created.

View solution in original post

3 REPLIES 3
wardy912
Memorable Member
Memorable Member

Hi @Rena 

 

 This could be a caching issue rather than the measure. Try creating a new measure as a first step in fault finding.

Creating a new measure is what made me realize I was saying if you see "Total # DT Events", then put the measure.  Not that I was telling the table which words to put.

Rena
Resolver II
Resolver II

Never mind.  The answer was in the question itself.  It is a switch true.  When I change the word, the value was deleting because the words no longer matched my table.  It has been too long since I created that, I didn't realize it was looking at a table and giving a value based on if it matched the table.  I had to go into Transform Data and edit the table that was originally created.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.