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 d...
Need Help
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