cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Error visualization

HI!

 

I'm having problems the following:

In power query I'm formulating the following column:

carogomez_0-1607951567234.png

And as a result: 

carogomez_1-1607951634589.png

But when i sort from power query and I want to do visualizations, no information is showed. 

 

carogomez_2-1607951799109.png

The column "LE" is blank and I don't understand why!

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi, @carogomez 

According to your description, I think you can create a measure:

LE1=IF( MAX[LE]=BLANK(), 0, MAX([LE]))

Then use this measure to replace the column[LE] in the chart, and take a look if the [LE1] in the chart is sill blank.

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

8 REPLIES 8
Community Support
Community Support

Hi, @carogomez 

According to your description, I think you can create a measure:

LE1=IF( MAX[LE]=BLANK(), 0, MAX([LE]))

Then use this measure to replace the column[LE] in the chart, and take a look if the [LE1] in the chart is sill blank.

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

Super User III
Super User III

Hi @carogomez 

Can you please share some actual data?  Or share the PBIX that you are doing these calculations in.

Adding together columns of any type abc 123 will result in an error even if they contain numbers. What is actually in the columns?

Not enough info is supplied to understand the issue and offer assistance.

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


This is how I have the information:

carogomez_0-1607960303750.png

carogomez_1-1607960316496.png

carogomez_2-1607960328737.png

 

And the formula of YTDfinal and YTGfinal is the following:

if [fechainicio]<=DateTime.Date(DateTime.LocalNow()) then 1 else 0

And the column LE is calculated from: YTDfinal+ YTGfinal.

 

Super User II
Super User II

Go back to Power Query.  The 2 things I can see are that the column datatypes are incorrect - they should be number (whole or decimal).

Also let's look at the new column in power query - it shouldn't have values only of 0 or 1.  So solve those 2 issues first

Thanx for your answer.

However the error persist:

I changed the datatypes to the three columns but still can't be visualized. 

carogomez_0-1607954557480.png

And for the LE column, there's only 1 and 0 values.

OK, I can see from that last picture that YTDFinal is 0 and YtGfinal are 0 for the row visible. So, are all values in Power Query correct? i.e. YTDFinal is 0 or 1, YTGFinal is 0 or 1 and therefore LE is 0 or 1?

 

OK, so the visualisation that shown in the first post. Tell us what aggregation is on each field please

This is how I have the information:

carogomez_0-1607960303750.png

carogomez_1-1607960316496.png

carogomez_2-1607960328737.png

 

And the formula of YTDfinal and YTGfinal is the following:

if [fechainicio]<=DateTime.Date(DateTime.LocalNow()) then 1 else 0

And the column LE is calculated from: YTDfinal+ YTGfinal.

Yes, my question is to do with what you've got in the powerbi visualisation.  I want to see the aggregations and columns.

 

 

Can you also confirm that all the Power Query columns are correct and LE now has either 0 or 1? and that is what you want

 

If you link your pbix, this will be sorted in about 10 seconds.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors