Forum Discussion

gtarrio's avatar
gtarrio
Frequent Visitor
6 years ago

Bar Chart Group and total

Hello It's possible to have on the same chart this information? SAR is the sum of each country a total. I'd like to have on the same chart the info of the total and detail   Hello!.      
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey gtarrio ,

 

by default this is not possible.

 

You have to create a table that is not related to your data model and with a column that contains all the values that you want to visualize on the axis of your chart. This table might look like this:

The Column Group is used as axis.

 

Unfortunately,  you have to map your measure, this measure might look like this:

Measure = 
CALCULATE(
    SUM('<your facttable>'[numeric column])
    , TREATAS(VALUES('<unrelated table>'[Country]), '<your dimension table>'[Counry])
)

Personally I use the Column "Group Identifier" to discover all the elements from the group including grouping elements like SAR, that groups three countries.

 

Hopefully, this provides some ideas about how to tackle your challenge.

 

Regards,

Tom

 

gtarrio's avatar
gtarrio
Frequent Visitor
6 years ago

Thanks for the idea, but how can I handle measures (Actual, Budge & Last year are measures)

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    Hey gtarrio ,

     

    In my sample measure, replace the numeric expression SUM(...) with your measure [...] and then use the new measure inside the visual.

     

    Regards,

    Tom