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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Louis66
Resolver I
Resolver I

Selected value unstable (sometimes returns 'BLANK' for no reason)

Hello, I have a problem with US electoral votes... when I click on Alabama, I have 0 votes for Democrats, which is OK :

Louis66_0-1667675632226.png

 

When I click on Arizona, I have a blank (!) :

Louis66_1-1667675691351.png

 

... and when I click on California, I have 55 (as expected) :

Louis66_2-1667675739445.png

Why would such a problem occur ? I check my database many times...

 

Regards,

 

Louis

4 REPLIES 4
Mikelytics
Resident Rockstar
Resident Rockstar

Hi @Louis66 ,

 

To help you I also need to see which columns you put into the KPI card as well as the measure definition if you built a mesaure

 

Best regards

Michael

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Hello Michael,

 

It seems I have a more fundamental problem... see, when I click on Nebraska, in 2020, for example, it should display 39.2% in favor of Democrats. For some reasons, I can only display Min, Max, Average, Count... but not the 2020 value. Something is not right here. Maybe it is in my modeling...

 

Louis

Mikelytics
Resident Rockstar
Resident Rockstar

Hi @Louis66,

 

what is your expected result? The first thing which comes in ym mind is that in your data model The Row for Arizona (Dimension table) does not match a value in your fact table (votes).

 

What is your expected result for Arizona and what does your measure look like?

 

If the expceted result is zero a solution could be that you put behind your formul "+ 0". But this only makes sense in specific constellations.

 

Can you please share your data model and the measures you are using in your chart?

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

Hello Michael,

 

My expected was 11 for Arizona :

Louis66_0-1667678987370.png

 

26 out of States are OK, the other 24 show 'Blank'.

 

Louis

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors