Suggest an Idea

[agilos_mla]

Hello,

It should be nice if we could set the axis format independently from the format set in the expression. Currently axis labels for numbers inherit of the format set at the measure level (Auto, Number, custom ... and measure expression). 

But for instance, when i use a dual only to display values at the specific data points, especially with %, it works well in the chart area but the format on the axis is broken (see below I would have get 100.0%, 0.0%, -100.0% while in the expression I've written : 

dual(
if([OrderDate.autoCalendar.YearQuarter]= '2020-Q4', num( Sum(Sales)/above(Sum(Sales)) -1, '0.0%'), ' ')
, Sum(Sales)/above(Sum(Sales)) -1
)

Maybe even much better would be to have option for values on data points at first, last, min, max data points/bars as according to visualization standards then to avoid to use ugly expression like "duals" 😉

[AndersLiu]

I have the same question with you,would you have been fixed it,thank you.

[AndersLiu]

My expression，
Dual
(
num( count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}
if(
aggr(
Count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Event_Speaker_Key)
,Speaker_ETMS_Code,Marketing_Campaign)=1
,Speaker_ETMS_Code)
)/
count(distinct {<Year_Month_Type={'Event End Date'},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={'N'},Event_Status={'Completed','Closeout Required'},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Speaker_ETMS_Code)
,'0.0%')
,
num(
count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}
if(
aggr(
Count(Distinct {<Year_Month_Type={"Event End Date"},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={"N"},Event_Status={"Completed","Closeout Required"},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Event_Speaker_Key)
,Speaker_ETMS_Code,Marketing_Campaign)=1
,Speaker_ETMS_Code)
)/
count(distinct {<Year_Month_Type={'Event End Date'},Year_Month={"$(vSelect_Year_Month)"},Campaign_Flag={'N'},Event_Status={'Completed','Closeout Required'},Speaker_Status={"Confirmed","Pending"},Speaker_Name=Speaker_Name>}Speaker_ETMS_Code)
,'0.0%')
)

[Linda1]

I support the idea that it would be possible to uncouple the measure format and the axis format in general.

For instance, it is interesting to see a value of 127,32€ as bar label or tooltip, but it is strange that axis labels are formatted like 25,00€/50,00€ etc. Why not make it 25€/50€ etc.? There is no value showing the two zero digits.

[agilos_mla]

Hey Linda, I overcome that issue by using a dummy measure that has the format without the decimal and put it first in the least of chart measures. It looks like QS is reading the format of the first measure to set the one on the axis then with the dual i succeeded to put the percentage with decimales on the line's last point 🙂  

[Linda1]

Thank you very much for your tip! Could be very helpful now and then. But unfortunately, I don't see any way to get rid of the legend entry for that dummy measure (but to use CSS) 😕 which is no opportunity for some customers

[Patric_Nordstrom]

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 
Patric

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.