Displaying text values instead of measures as data points in the combo chart

[sivadandu]

Hi All,

i have requirement of displaying Text values in place of measures as data points in the combo chart. 

Date                Dimension Category                    Value

1/1/2022           Section1                                              25

2/1/2022          Section2                                                  -15

3/1/2022          Sectoin3                                             25 

4/1/2022           Section4                                                10

5/1/2022            Section5                                            -15

6/1/2022            Section6                                           30

I would like to see the  Dimension Category    text in the data points of the combo chart instead of the measure values  (max(Value)). It should appear even width of the bar has been reduced near to the minimum value and the Dimension category should be displayed along with X-axis, I mean the data point values should be displayed horizontally. Please suggest.

And it that possible to have different kind of markers  at the tip of the bar, based on certain conditions as shown in the second picture (thumbnail.jpg). 

Dimension : Date

Measure : sum(Value)

Thanks in advance.

--

[chris_djih]

Looking into the Screenshots you added, what you may looking for are reference Lines (under Add-Ons).
There you can specify a concrete value and give it a marker with cusotm text in the chart.

If you still want something like text in the chart itself. you have two options (which can be combined)
1. use Dual('text for Value = 10', 10)

2. custom mouseover: under Quickinfo you can manipulate what is shown, if you hover over the data points.

But i'm quite confident that the reference line is your way to go!

[sivadandu]

I really appreciate your reply and time taken to look into my issue..

May be, i haven't explained the issue properly, earlier.

I have already tried with dual function, but the text not shown as data points. I have tried creating another measure with Maxstring(<TextColumn>), then it started appearing  ColumnText as a datapoint.  

But the text tilted vertically. My another challenge to make it appear the text along with X-axis (I mean horizontally).

Please share you ideas to make it happen. 

Thanks,

SD

[chris_djih]

Hi as far as i know there are only 3 possible was to achieve your goal
1. with dual and some hacks to force the view to display the names:

2. with reference lines

3. with custom mouse over.


if you want to understand more one of these solutions i can give you the .qvf otherwise i'm out of my ideas 😕

[sivadandu]

Excellent.... You are Champion. 

I really appreciate, if you can share the qvf to understand more about your visualizations.

Just out of curiosity, is that possible to display the lables horizontal to the X-axis in the first picture.(Instead of Vertical labels in the first solution. ie> using dual function ).

Now, it makes sense to me, what you told me earlier about reference lines in the second solution.

Regards,

Siva

[chris_djih]

as far as I know, ther is no chance to display the labels horizontically.
the secret is to take the format form the measure definition:

then it will display the dual vaule.

See full app attached.