How to visualize coterminous number ranges with associated values?

[chroberts]

Hello,

I have a data table following the below schema:

And I would like visualize it in a way very similar to the highlighted portion below:

Any ideas on which visualization to use for this?

Your help is much appreciated!

[lbendlin]

Your sample data does not match your expected outcome.  Please validate.

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

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

[chroberts]

Hello,

Below is a table for use:

Category	Value	From	To
1	60	40	41
1	40	41	41.4
1	60	41.4	45.8
2	60	40	45.8

And here is a revised screencap of the expected outcome, with the values not included in the table scratched out:

 

In general, I'm just looking for a suggestion as to how to graph these From and To segments while displaying the associated value.

Thanks,

Chris

[lbendlin · Accepted solution]

For the time being you would have to create your own sampling ( for example in .1 steps)  , in the future this might be possible via custom visuals.

One of the problems you will have is that the "40"  label will not fit into the allocated space between 

41

41.4

So you will likely have to do it with colors and legends instead. see attached for a sample implementation.