search

okviz / free-visuals

Power BI free custom visuals
MIT License
24 stars 7 forks source link

Card with States not formatting Percentage with Calculation Group #313

Closed Jake-BIV closed 1 year ago

Jake-BIV commented 2 years ago

Describe the issue IS: Card displays a decimal Value Should/be: Card should display a percent formatting per the Measure Formatting and Calculation Item Formatting.

To reproduce

  1. Create a measure and set formatting to percentage
  2. Create a calculation group (in tabular editor) and calculation item. Set the item format to Percent.

Affected environment

Power BI Desktop: Version: 2.100.1401.0 64-bit (December 2021)

Tabular Editor: v2.16.5

REQUIRED: Repro file TestModel.zip

IMPORTANT: We don't consider issues without a sample report!

Screenshots image

dainiusbw commented 2 years ago

Hello,

I can confirm, that there is issue in handling of formats of measures in Card with States. Not only in case of percentages, but in general (maybe side-effect of "hardcode" in script of visual). Not only in case of calculation groups, but in case of native format of measure (same percentage).

Here examples when measure as "%" Firs Microsof card, second - Card with states Percents

Please check and fix.

sqlbi student, Dainius B

dainiusbw commented 2 years ago

My credentials: Desktop: Version: 2.103.661.0 64-bit Card Pro version:1.6.8

Guido2022 commented 2 years ago

This is a serious issue and it is definitely affected as soon as there are calculation groups and a format string at least on one of the items. The measure involved in the calculation group isn't even the same as used in the Card with States. This means, the % number gets lost and a decimal is displayed. Please fix this otherwise the card can never be used along with calculation groups. Thank you.

Jayclaw commented 2 years ago

Having this problem as well and since we use this visual on the front page of most of our reports it currently means that we can't use any format string expressions in calculation groups.

Please fix!

alexdc-24 commented 1 year ago

This will become more apparent now with the release of dynamic formats for measures. I have a calculation group for now but have also tested with the dynamiic format preview feature and it doesn't work.

riccard0russ0 commented 1 year ago

We have temporarily suspended the development of new features and addressing bugs that aren't related to security. This decision is based on the fact that the new Power BI built-in Cards supports almost all Card with States functionalities. We will reconsider this decision if our plans change.