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

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!

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      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.