Forum Discussion

acanepa's avatar
acanepa
Icon for Resolver I rankResolver I
9 years ago
Solved

Filter by columns on the fly

Hello,   I want to know if is possible to filter by columns for a lineor barchart. For example let's say I have 3 measures, pageviews, visits and bounces. And I want to graph them in an line chart...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    You could take this approach.

     

    Create a table called Measures. The contents will be 

    MeasureName , MeasureID as column names

    The rows will be

    pageviews , 1

    visits , 2

    bounces, 3

     

    Create a measure in the data model as follows :

     

    Showvalue=switch (TRUE,
    Min ( Measures[MeasureID] ) = 1,
    ( [pageviews] ),                            /* replace this by your fomula for pagevies or if already exists put that measurename */
    Min ( Measures[MeasureID] ) = 2,
    ( [visits] ),                                      /* replace this by your fomula for visits or if already exists put that measurename */

    Min ( Measures[MeasureID] ) = 3,

    ( [bounces] ) )                               /* replace this by your fomula for bounces or if already exists put that measurename */

     

    Now create a slicer with Measure table column MeasureName .

     

    In the chart or table , use the measure Showvalue as your values column to chart or display in table and you will have the results.

     

    Credit for this solution goes to Anonymous

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

You could take this approach.

 

Create a table called Measures. The contents will be 

MeasureName , MeasureID as column names

The rows will be

pageviews , 1

visits , 2

bounces, 3

 

Create a measure in the data model as follows :

 

Showvalue=switch (TRUE,
Min ( Measures[MeasureID] ) = 1,
( [pageviews] ),                            /* replace this by your fomula for pagevies or if already exists put that measurename */
Min ( Measures[MeasureID] ) = 2,
( [visits] ),                                      /* replace this by your fomula for visits or if already exists put that measurename */

Min ( Measures[MeasureID] ) = 3,

( [bounces] ) )                               /* replace this by your fomula for bounces or if already exists put that measurename */

 

Now create a slicer with Measure table column MeasureName .

 

In the chart or table , use the measure Showvalue as your values column to chart or display in table and you will have the results.

 

Credit for this solution goes to Anonymous

  • acanepa's avatar
    acanepa
    Icon for Resolver I rankResolver I
    9 years ago

    Works great!. Thanks for the help!.

  • acanepa's avatar
    acanepa
    Icon for Resolver I rankResolver I
    9 years ago

    Do you know if you can filter axis?, for example percentages against whole numbers?. I'm using FORMAT but is not working.

    • dkay84_PowerBI's avatar
      dkay84_PowerBI
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      I'm not sure what you are asking.  Try the axis options within the visual settings, or try changing the data type for the data displayed on the Y axis.  Not sure what "percentages against whole numbers" means.

      • acanepa's avatar
        acanepa
        Icon for Resolver I rankResolver I
        9 years ago

        Hi,

         

        Sorry for explain badly. 

        I'm using different meausures or metrics. A group of metrics use percentages for show data and other group of metrics use whole numbers to show data. I'm trying to format the meausures with the function FORMAT in DAX, but that converts numbers to text.

         

        Thanks in advance for your response.

         

        Rergards,