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

3 Replies

  • 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