Data Changing When Creating Visuals

[MExtross]

Hello! I am trying to create visuals however occasionally some data will be omitted from the visual (my excel file had values for 8 quarters but when creating the visual it only shows 4 quarters). Additionally, sometimes the data shows up in the visual in a different order (months of the year shows up out of order). Does anyone know how to fix this? I have double checked that the full data has been imported...

[chethan]

@MExtross

Occasionally some data will not be omitted Until you filter the data from the Year in the visual level filter.

until you do this you data will keep omitting occasionally & even every time.

Regards,

Chetan K

[fhill]

Make sure your Month is defined as a Date in Power BI, this shoudl help your sorting order.  If you just have a TEXT column of Month Names, than April & August come first b/c it doesnt' know it's a date.

If you find smaller charts are missing column names, try chaning the X-Axis 'Type' value under formatting to 'Categorial' instead of Continuus.  

Hope this helps, if not, please post some data examples so we can duplciate the error on our end.

Thank You,

FOrrest

[Eric_Zhang]

---

@MExtross wrote:

Hello! I am trying to create visuals however occasionally some data will be omitted from the visual (my excel file had values for 8 quarters but when creating the visual it only shows 4 quarters). Additionally, sometimes the data shows up in the visual in a different order (months of the year shows up out of order). Does anyone know how to fix this? I have double checked that the full data has been imported...

---

@MExtross

I don't think Power BI would ommit any data in the dataset, for the quarters, you may not put the correct column in the visual. As to the months of years showing out of order, could you ensure that the months column are a date type column instead of text type like 'Jan', 'Feb' etc, for latter case, the months would show in a alphabetical order.

For further suggestion, please post some sample data and expected output.

[MExtross · Accepted solution]

Hi @Eric_Zhang and @fhill,

Thanks for replying!

I was actually able to fix the error myself, surprisingly. Basically since there were multiple quarters (Q1 for 2016 and Q1 for 2017, and so on for those two years), it actually combined them, hence why there were only 4 quarters showing instead of 8. I just had to add the year in for power bi to keep them separate.

As for the months, I added another column and put numbers in for the order I wanted the months to appear and then "sorted by number", which solved the issue!

Overall, surprisingly easy fixes!

Thank again,

Maegan