Forum Discussion

fibaek's avatar
fibaek
Icon for Helper I rankHelper I
5 years ago

Funnel Chart Can't Display Percent When There is a Calculation Group in the Data Set

Hi All,

I have a report with a funnel chart visual, but when I create a caculation group in the data set the funnel cannot display values as percent. 

The data is structured in a table with three different measures that will be displayed in a standard funnel chart. Each values is a calculated decimal values representing a percentage.

Apples

Pears

Oranges

0,62

0,28

0,10

The funnel looks something like this:

This works perfectly fine as long as there are no calculation groups in the data set – the values are displayed properly as a percentage value. Even with Discourage Implicit Measures enabled. However when I add a calculation group into the mix, the values are displayed as regular decimal values. The calculated values are formatted as percentage.

I can create a calculation group to achieve this, but creating a separate group (and thus a table) for each funnel visual isn’t really an option.

Does anyone know of a solution to this issue? It looks like a bug, but I'm hoping there is some kind of work around for it.

Examples:

Sample dataset without a calculation group 

Sample data with a caculation group 

Cross post to the issues channel as it seems like a bug in the visual: Cross post to issues 

Kind regards,

/Sune

Need Help

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi fibaek ,

    It's amazing，how to get the table"Fruit salad"?

    I create this table in  Sample dataset without a calculation group ,Just enter data

    Then I get the below:

     

    And base on Sample data with a caculation group  , I create a new table:

    Measure = IF(MAX('type'[type])="Apple",SUM(Sales[Apple]),IF(MAX('type'[type])="Pear",SUM(Sales[Pear]),SUM(Sales[Orange])))

     

     

    Final get:

     

    You could download pbix if you need.Wish it is helpful for you!

     

    Best Regards

    Lucien

     

     

    • fibaek's avatar
      fibaek
      Icon for Helper I rankHelper I
      5 years ago

      Hello v-luwang-msft 

      The 'fruit salad' table is the calculation group in the data set.

      If I understand your example correctly you create a new table for the funnel visual. Consequently I would have to make five individually maintained tables in the data set if I need five funnelcharts in my report. 

      I don't understand how adding a cacluation group to the data set - even one that is not related to the data in question - can break the formatting of another visual. The visual works fine, except for the format.

      /Sune