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

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

sivadandu — Wed, 26 Jan 2022 18:52:21 GMT

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.

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

chris_djih — Thu, 27 Jan 2022 10:30:28 GMT

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!

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

sivadandu — Fri, 28 Jan 2022 18:41:08 GMT

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,

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

chris_djih — Mon, 31 Jan 2022 14:48:26 GMT

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 😕

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

sivadandu — Tue, 01 Feb 2022 22:21:25 GMT

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

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

chris_djih — Thu, 03 Feb 2022 07:48:55 GMT

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.