Forum Discussion

daledale's avatar
daledale
Frequent Visitor
6 years ago
Solved

Line Chart - 2 budgets 1 Node

Hi everyone,   I'm trying to create a line chart that change with according 2 slicers. One slicers contains Nodes (1,2,3,4, etc...). The other one contains Budgets (A, B, C, etc...) The line c...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi daledale,

     

    check this out.

     

    CATEGORY_NODE = 'Table'[Nodo] & ", " & 'Table'[SDO]

     

     

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

daledale's avatar
daledale
Frequent Visitor
6 years ago

Sorry for my late reply, I'm really stucked with this PBI and need to solve many issues I cannot find solutions for..

This is the way I have my tables (it's actually an unpivotted table)
NODE - CATEGORY - COUNTRY - ATTRIBUTE - VALUE
1                 A                   XX               Q1               $$

1                 B                   XX                Q1                $$
2                  A                 XXXX             Q1                $$
2                  B                 XXXX             Q1                $$

And so on... 
I have 2 slicers, which I use to filter my line charts.
1 is for NODEs, one is for CATEGORY.
If I filter by Category, I'm ok. Because I see a line for Category A, belonging to NODEs 1, 2, etc...
But if I filter by NODE, it shows me A+B as only one line in the chart.

Right now I have the NODEs in my legend and Attributes in my Axis.

 

 

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi daledale ,

 

maybe you could create a calculated column (Category & Node) and use it in the legend.

 

CATEGORY_NODE = CONCATENATE('Table'[CATEGORY],'Table'[NODE])
 
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
  • daledale's avatar
    daledale
    Frequent Visitor
    6 years ago

    Thanks again, but what I need is to show them as 2 different lines when I filter by Node.
    Meaning, I want to filter Node 1, and see a line for Category A, and a line for Category B.

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      So?

      If I answered your question, please mark my post as solution, this will also help others.

      Please give Kudos for support.

      • daledale's avatar
        daledale
        Frequent Visitor
        6 years ago

        mwegener sorry, I might not be expressing myself correctly. 

         

        Maybe with Screenshots it's easier:

        Node = Nodo
        Category = SDO
        My Node of Brasil has both sub categories. But when I filter only by Node, it adds up both:

        Filtering by Node and Category AFiltering by Node and Category BFiltering only by Node shows added up both

         

        I hope this claryfies my issue, Thanks again for the support!