Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
desert_dweller
Contributor
Contributor

Slider Chart

I have a requirement to create a chart that displays possible values for two measures for a dimension with the actual values indicated somehow. See the attached picture. Each bar represents possible values in a measure and the external arrows represent the dimensions value for each of the measures. Any tips on which chart type or extension I could start with to accomplish this? 

 

 

Slider.png

Labels (1)
  • Chart

1 Solution

Accepted Solutions
OmarBenSalem

Maybe something like this?

bar chart with 2 dimensions 

Dim1=valuelist('Measure1','Measure2')

Dim2: the dimension you want to show

as a measure :

if(valuelist('Measure1','Measure2')='Measure1',sum(Expression1)/sum(total Expression1)
,sum(Expression2)/sum(total Expression2))

 

result:

OmarBenSalem_0-1650980376371.png

 

View solution in original post

2 Replies
OmarBenSalem

Maybe something like this?

bar chart with 2 dimensions 

Dim1=valuelist('Measure1','Measure2')

Dim2: the dimension you want to show

as a measure :

if(valuelist('Measure1','Measure2')='Measure1',sum(Expression1)/sum(total Expression1)
,sum(Expression2)/sum(total Expression2))

 

result:

OmarBenSalem_0-1650980376371.png

 

desert_dweller
Contributor
Contributor
Author

Thank you, this is very close and will give me a good start. Thanks for pointing me in the right direction.