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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
carogomez
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
v-robertq-msft
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
v-robertq-msft
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.

PhilipTreacy
Super User
Super User

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.

 

HotChilli
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.