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.

amitchandak's avatar
amitchandak
Super User
6 years ago

Not sure I got it completely. But if you put the budget in legend, then it should show two line. 

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.