Forum Discussion
Scatter plot doesn't match points rightly
Anonymous，
Do you connect to SSAS database or SQL Server database in Power BI Desktop? If you connect to SQL Server using DirectQuery, you are able to use Query Editor in Power BI Desktop.
Also please open updated PBIX file.
Regards,
Lydia
No Issues case in scatter and line chart don't vary much.
So why mine is stable i have created a new table having the values of month. Created a relation with actual data table, and will create filter from this table
Table 1 ---> Actual Data
Table 2 (need to be created) ---> Only Month Name/ Month Year Name eg [1,2,3,....,11,12]
Create a relation between these two ( single side filter from table 2 to table 1 )
Create the filter on Table 1 - so that when you filter the table, table 2 values will not be affected, hence measure will be calculated for all the values.
If your filter filters out the values in table 2 you will not see those months hence no zeros.
Thanks
Vinayak
Well kohlivinayak, I think the issue now comes to my database, because when working with DirectQuery from Sql Server I can't create new tables, only measures and columns. Don't you now any way to solve it without creating a new table?
Well i am not able to think of any solution with creating a new table as of now, but just a thought, you can create your new table with sql query in direct connection instead of in powerbi.
kohlivinayak well yes I think there's no way better than this unfortunately.
Thank you very much for your great hints.
Let me ask you some more. In the example you sent me there were charts ordered by month names. I opened another post about it some time ago, because I didn't find a way to do that, only converting names to numbers was good, but that's not great. I noticed you built a new table in Power BI with dates and month number, getting dates from DAX Calendar function. Do you think this is way you get months names ordered chronologically or is there something else?
Thanks
Well we have an option of sort by column in modeling tab.
What we do is create a new column and assign values in which we want to sort them.
So now we will have a table like this
Month | Month No
Jan | 1
Feb | 2
Mar | 3
In the report view select month column, go to modeling tab and select sort column by month no. This will order months according to month no column.
Important things to remember
- If if a value is repeating it should have same coresponding integert value through out the table.
- if you create a new column with dax using calculations on Month column, you will not be able to sort month by that column.
Thanks
Vinayak