Forum Discussion

Mahadevaraobc's avatar
Mahadevaraobc
Helper II
7 years ago

Display new Value...

Hi All,

 

I have a dataset with 2 columns,

1 - Region (LA and NA)

2- Country.

I would like to display this in a line chart where 

1st visual should have 3 values AMS, LA and NA (AMS should have value of LA and NA).

2nd drill down, if LA is selected it should display all LA countries, if NA selected it should display USA and Canada.

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Mahadevaraobc ,

     

    I created a sample for your reference.. If it doesn't meet your requirement, please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

     

    1. Create a calculated table as a slicer table.

     

    filter = VALUES(Table1[Region])

    2. Create a measure as below.

     

    Measure = 
VAR sele =
    SELECTEDVALUE ( 'filter'[Region] )
RETURN
    IF (
        sele = "LA",
        CALCULATE ( SUM ( Table1[values] ), FILTER ( Table1, Table1[Region] = sele ) ),
        CALCULATE ( SUM ( Table1[values] ) )
    )

    • Mahadevaraobc's avatar
      Mahadevaraobc
      Helper II
      7 years ago

      This answers small portion of my question.

      How can i combine values of LA and NA and show that in a line chart with values of LA, NA and Combined.