Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Value Field keeps wanting to sum or count

I have added a new column in my query to calculate "the number of days to X" i.e. Subtracting one date from another. I have set the modelling in the report to "do not sumarize" but when I drag it in...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Except for the table visual, all other visuals will summarize the values of the "Value" tag.

     

    “All I want to see is: the number of days it takes to do X by Country and if I can, show the number of shops that have achieved X.”

    Drill mode in a visual in Power BI 

    The histogram can also aggregate the values of multiple dimensions, please refer to my example.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Except for the table visual, all other visuals will summarize the values of the "Value" tag.

 

“All I want to see is: the number of days it takes to do X by Country and if I can, show the number of shops that have achieved X.”

Drill mode in a visual in Power BI 

The histogram can also aggregate the values of multiple dimensions, please refer to my example.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.