Forum Discussion

carlol's avatar
carlol
Icon for Resolver I rankResolver I
6 years ago

Slicer Selection , define specific value selected

Hi    I have a Slicer called Month , Jan to Dec values    Sections of my dash board I only want to illustrate the month based on the Slicer selction and exclude Dec; this is working, (filter: Mon...
Need Help
JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

It is possible, but you'll need to create a measure that displays only the DEC values. When you add the value column (where your slices will work it's magic) and the december measure, your users wouldn't need to select the DEC seperately. 

  • carlol's avatar
    carlol
    Icon for Resolver I rankResolver I
    6 years ago

    I have the two measures 

     

    Measure % -- Returns % based on Slicer Selection 

    % = Round(Divide(SUM('IHFD vwKPI'[Numerator]),SUM('IHFD vwKPI'[Denominator])),2)
     

    Measure %Dec -- Returns % based on Month = Dec

    %Dec= CALCULATE(Divide(SUM('IHFD vwKPI'[Numerator]),SUM('IHFD vwKPI'[Denominator])),FILTER(ALL('IHFD vwKPI'[Month]),'IHFD vwKPI'[Month]="Dec"
    ))

     

    Issue: I want to display this in a bar chart but only one measure is allowed to be defined as the value

     

    Trying to figure out how to group these into one Measure