Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with date measures when using calculation groups for formatting #703

Closed
anderseik opened this issue Dec 2, 2020 · 5 comments
Closed
Labels
AS/PBI issue Indicates an issue in the Analysis Services engine or AMO/TOM waiting for author

Comments

@anderseik
Copy link

When setting up a calculation item to format a decimal number to percentage all date measures in the model is broken and returns the name of the date format instead of the date itself.

Steps to reproduce the behavior:

  1. Go to tabular editor and create a new calculation group and item.
  2. Expression = SELECTEDMEASURE ()
  3. Format string Expression = "0.00000%"
  4. Save the new items to the Power BI file
  5. Add the calculation item as a filter to the visual where the decimal is set
  6. Activate the calculation item

Expected behavior
The decimal measure should convert from decimal number to percentage format when the calculation item is active. No other changes to behavior expected

Observed behavior
When saving the calculation group and item created in TE the returned values in date measures are broken.

Calculation group and item created, saved to power bi desktop
image

Percentage formatting working properly, date measures returning "General Da e"
image

The selected date format for the dates
image

Changing the date format for the top measure
image

New result of top measure after refreshing
image

Application specifics

  • Tabular Editor version: 2.12.4 (also tested on 2.13.1)
  • Semantic Engine used: Power BI Desktop October 2020 (also tested on November 2020)
  • Model Compatibility Level: 1500?

Additional context
The date measures are always broken when saving the calculation group and item to the power bi model. The date measures go back to normal behavior if I delete the calculation item.

I have tried to change the regional settings of the pbix from norwegian to English (United States) and English (United Kingdom)

Region settings in windows:
image

pbix file used
dates.zip

@anderseik anderseik added the bug Anything that is supposed to work, but doesn't. label Dec 2, 2020
@otykier
Copy link
Collaborator

otykier commented Dec 3, 2020

It seems to be an issue with the AS engine and dynamic format strings on calc groups. Will reach to the AS engine team.

@marcosqlbi
Copy link

Update: the fix is in progress, but it will be deployed in February/March 2021.

@anderseik
Copy link
Author

Update: the fix is in progress, but it will be deployed in February/March 2021.

Thanks to you both Daniel and Marco, appreciate it

@otykier otykier added PBI Desktop issue and removed bug Anything that is supposed to work, but doesn't. labels Feb 1, 2021
@otykier
Copy link
Collaborator

otykier commented Mar 2, 2021

@anderseik did you have a chance to see if the issue is resolved with the February release of Desktop?

@otykier otykier added AS/PBI issue Indicates an issue in the Analysis Services engine or AMO/TOM waiting for author and removed PBI Desktop issue labels Mar 2, 2021
@anderseik
Copy link
Author

@otykier checked now, not able to recreate issue. It's worth mentioning that I do not have access to the PC and the model I was working on at the time I raised the issue, but as far as I remember, this was a general issue with all models I tested it on.

thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
AS/PBI issue Indicates an issue in the Analysis Services engine or AMO/TOM waiting for author
Projects
None yet
Development

No branches or pull requests

3 participants