Segmentation with two options to display multiple measures

[Syndicate_Admin]

Hello

I have a single-value slicer with 2 options: Kilograms or Units

And I want that, depending on this value marked in the segmenter, 3 measures are shown in a graph respectively that are in the same table of the model:

- If I select Kilograms: Sales Forecasts in Kg, Actual Sales in Kg, and % Difference

- If I select Units: Sales Forecasts in Units, Actual Sales in Units, and % Difference

How can I control which measures should be displayed in the chart based on the value selected in the segmenter?

Thank you

[Syndicate_Admin]

This @सेनिबेनी,

I would use this type of formula in each of the formulas you want to display:

IF ( SELECTEDVALUE (columna donde está la opción Kg / Unidad) = "Kilogramo", [su medida en Kg], [su medida en unidades] )

If you can share more information or send a file I can try to help more effectively

[Syndicate_Admin]

This @_आंद्रादे,

First of all, thank you very much for your quick response.

With the formula you have indicated I can only show one measure in the IF when "Kilogroamo" is selected, but I need to show 3 different measurements.

How could I display the 3 measurements in Kg when you select "Kilogram" and if you select Units the other 3 respective measurements in units?

Thanks a lot!

[Syndicate_Admin]

Hola @_ஆன்றதே,

Thank you so much for your help!

[Syndicate_Admin]

You're welcome.

[Syndicate_Admin · Accepted solution]

This can be done in a number of ways, for example, using parameter filters or calculation groups, but it depends on how you have your model and formulas.

The solution I presented would have to put this logic into your 3 measurements.

Like I said, if you could share some images of how you have your data models and your formulas, it might be more effective to help you.