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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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