Continuous Categorical Line Chart

[aburling1989]

Hi,

I was wondering if it's possible to set a continuous categorical value on a line chart? As you can see in the below screenshot the data points are disjointed.

I'm aware this can be set to 'Date' which would solve this, however, I need the date specifically in "QQ YYYY" format and everytime I try and conert the date to this format it automatically switches it back to the category variable.

I've tried some custom visuals which sort of worked however each had their own limitations (such as not being able to include markers). Maybe there's a much simpler solution that I'm completely overlooking. Appreciate any help anyone can offer here.

Thanks!

[aburling1989]

Hi Rita,

Many thanks for the response. Unfortunately this option doesn't work. If I just add the year, I get the option to set the type as 'Continuous', however as soon as I add quarter into the hierarchy this option is no longer available and it auto sets to categorical.

The closest I've been able to get is by using the 'Line Chart by Akvelon 2.0.1' custom visual, which supports a continuous line on categorical information (example below). However, for some strange reason this visual does not update if there is only 1 selection available in the legend (no idea why) so I'm trying to find a way to stick to the standard line chart.

Thanks,

Ashley

[Ritaf1983]

Hi @aburling1989 as I said previously to help more I need data to work with so : 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[aburling1989]

Hi Rita,

https://drive.google.com/file/d/1c1n_lzwzfUOq_fxfU4MvGCEVl3BplcVF/view?usp=drive_link

Attached is a link to an example file. Top top chart is what I'm trying to set as continuous. The bottom chart is the desired outcome, I'm just trying to get include the specific "QQ YYYY" format.

Thanks for the help!

[Ritaf1983]

Hi @aburling1989 
The link shared without access

[Ritaf1983 · Accepted solution]

Hello @aburling1989 ,
it's very strange, I tested my reports and the continuous axis worked on all types of fields, including texts.

Try to create a hierarchical X-axis, first, put a year, and then place the quarters underneath it in the required format.

Please provide an example if it doesn't work.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly