Dynamic change of the measurement of numbers or % values with Switch or Variable

[Syndicate_Admin]

how about my friends I need your help.. I am currently working with my powerBi and would like to see if it is possible to change the value measure by selecting by segmetation.

The problem I face is that in the rebaba selection it contains data in %, and by means of switch it brings me the values in a general format and the data must be presented in the same format as this measure.... I have already tried doubling the leaves and I do not think it is a better practice. I attach the Pbix file in case you are interested in giving me a hand 😞

https://drive.google.com/file/d/1-NIbZO6FTLMvkEPA_p84fPp-cq-XbYTl/view?usp=sharing

[amitchandak · Accepted solution]

@Syndicate_Admin , if you want to change formatting of the measure when you choose measure you have to use calculation groups using tabular editor

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

https://www.youtube.com/watch?v=vlnx7QUVYME

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Try this:

Measure = SWITCH(MAX('Tabla (2)'[KPI]),"Rebaba",SUM(Tabla[Rebaba])/ CALCULATE(SUM(Tabla[Rebaba]),ALL(Tabla)),"Volumen", SUM(Tabla[Volumen]) )

But both of these two are the same format(number ,not with %).

In case you want to display is different formats, you may try to use calculation groups, refer to:

10 ways you can use Calculation Groups in Power BI

How And When To Use Calculation Groups In Power BI

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

[Syndicate_Admin]

It is not what I need, in the example it has the same format for all values. I want to change between % and decimal values and then USD

[amitchandak · Accepted solution]

@Syndicate_Admin , if you want to change formatting of the measure when you choose measure you have to use calculation groups using tabular editor

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

https://www.youtube.com/watch?v=vlnx7QUVYME

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...