Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI!
I'm having problems the following:
In power query I'm formulating the following column:
And as a result:
But when i sort from power query and I want to do visualizations, no information is showed.
The column "LE" is blank and I don't understand why!
Solved! Go to Solution.
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.
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.
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
Proud to be a Super User!
This is how I have the information:
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.
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.
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:
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |