cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Chart showing flat line for month not selected

Hi 

 

I need to remove the flat line for month not selected 

 

cupedersen_0-1603784265596.png

 

I need to only show those selected Year 2019/2020 jan - sept. so i dont wanna show oct to dec. here.. choises can be differnt 

 

Any suggentens ?  

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi, @cupedersen 

According to your requirement, I think that you should change the type of Axis of the line chart ([Date]) to “Text”, you can follow my steps:

  1. Go to power query editor, change the type of [Date], like this:

v-robertq-msft_0-1603791134069.png

 

  1. Go to the page filter, filter the [Date] column, like this:

v-robertq-msft_1-1603791134083.png

 

And you can get what you want, like this:

屏幕截图 2020-10-27 173415.png

 

You can download my test pbix file here

 

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

1 REPLY 1
Community Support
Community Support

Hi, @cupedersen 

According to your requirement, I think that you should change the type of Axis of the line chart ([Date]) to “Text”, you can follow my steps:

  1. Go to power query editor, change the type of [Date], like this:

v-robertq-msft_0-1603791134069.png

 

  1. Go to the page filter, filter the [Date] column, like this:

v-robertq-msft_1-1603791134083.png

 

And you can get what you want, like this:

屏幕截图 2020-10-27 173415.png

 

You can download my test pbix file here

 

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.