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.

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.