Forum Discussion
Incorrect number formatting disconnected table
Dear All,
I have created a disconnected table including 3 values "Values", "Qty" + "Orders".
With a measure I reference to the original measures in order to show optional Values, Qty or Orders.
...
...
Your help is very much appriciated.
Thanks a lot
Andreas
7 Replies
AnSchmi , if you want keep number formatting the new measure should have that.
If you want different number formatting then use calculation group
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/Dear amitchandak,
what does it mean ... the new measure should have that... ????
After March 2022 update I even have problems to change formatting of regular measures.
Update only applied after restarting the program.
Best RegardsAndreas
You can use the FORMAT function to manually set the format of each branch (which outputs the result as text) but there isn't a way for DAX to automatically inherit the formatting from the underlying measures.
As amitchandak mentions, currently, the only way to really achieve dynamic formatting is via calculation groups (see this article for detail) but other options might eventually be coming in the future:
https://ideas.powerbi.com/ideas/idea/?ideaid=09c2a6d2-d215-4d68-b500-21167d177461Good Morning, AlexisOlson & amitchandak,
thanks a lot for your immediate reply.
I'm familiar with the calculation groups and I have implemented it in my model as well.
However I failed creating 2 calculation groups in order to show column value as well as line value.
I would like to show column values, qty over time in a line and stacked column chart and the same
time LY value in %.
I know that this is possible but so far I could not find an articel helping me to understand and implement this szenario.
Do you have any advise ?
Thanks a lot in advance.Sorry, I don't understand what you're asking.
