Forum Discussion

StarwoodTech's avatar
StarwoodTech
Frequent Visitor
9 years ago

Clicking visualization does not refresh data view

I have a report which has 2 pie charts. The data feeding the pie chards are calcualted fields and columns that I have added to my dataset. The issue is that, unlike adding an exisiting field to a pie...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

StarwoodTech

 

I can't reproduce your issue. When I populate a calculated field into a pie chart and click one slice, it will filter other visuals properly.

 

 

 

Ps: Category * is calculated field.

 

What's the formula you applied in that calculated column?

 

I suggest you add custom column in Query Editor with Power Query syntax.

 

Regards,

  • StarwoodTech's avatar
    StarwoodTech
    Frequent Visitor
    9 years ago

    Thanks for helping. Some added info...

     

    When I add the data as a drag and drop from an actual data field from the data source, visualization behave as expected. When I create a new measure or column, then add the results of that to the pie, it does not.

     

     

    In the example above, I have a new measure called "On Budget" which is a count of projects with a CPI of a certain range. I created 3 of these that make up the pie and add them. It displays great and allows the use to slect a slice. However upon that selection, the sorrounding visualizations do nothing, even though there is a postback. Not sure why it will not repeat the same behavior as it would if I used any other field supplied by the dataset that is not a new measure or column.