topic Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns in DAX Commands and Tips

using SELECTEDVALUE and SWITCH to choose multiple measures or columns

horza — Mon, 24 Aug 2020 15:36:30 GMT

I'm fairly new to PowerBI. I've got to grips with using SELECTEDVALUE and SWITCH to accomplish a slicer that picks a measure to show in a single visualisation - in my case a clustered bar chart. I want the choice in the slicer to pick a set of measures to show in the clustered bar chart.

Imagine the slicer is selecting for an geographical area and in the bar chart I want to show a balance, incomings and outgoings for that area.

The code I have for the measure so far is below.. can I return some kind of collection??

WhichSalesArea =
var MySelection = SELECTEDVALUE('Measure Selection'[Measure Name], "Sales")
return SWITCH(TRUE(),
MySelection="Area1",[Area1],
MySelection="Area2",[Area2],
MySelection="Area3",[Area3],
MySelection
)

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

amitchandak — Mon, 24 Aug 2020 16:33:40 GMT

horza , refer if this can help

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

horza — Mon, 24 Aug 2020 21:01:45 GMT

Thanks for the links! The 'Guy in a cube' one is particularly interesting. However I can't apply that to the problem at hand.

The first two links are relevant but they only instruct on how to do the basic task of selecting one measure/column in the slicer. I can do that just fine. The problem is how to select multiple measures/columns.

To be more specific: Lets say I have a slicer where I can pick America, Asia and Europe. If I pick America I see a clustered chart where I can see three columns per time period e.g. balance, incomings, outgoings. I can pick Asia and see the balance, incomings and outgoings for each period in Asia... and Europe. The data for America, Asia and Europe is in 3 different tables. The balance, incomings and outgoings are in 3 different columns.

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

HotChilli — Mon, 24 Aug 2020 23:53:55 GMT

If the data for the 3 geographical areas is at the same granularity, why not make things easier by combining in one fact table?

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

horza — Tue, 25 Aug 2020 11:55:14 GMT

Can you elaborate or provide an example?

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

Anonymous — Tue, 25 Aug 2020 13:30:43 GMT

Hi horza ,

Can you share some sample data in text format.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: using SELECTEDVALUE and SWITCH to choose multiple measures or columns

forgetmenot — Thu, 26 Oct 2023 13:05:12 GMT

horza Did you find solution do this?

I'm having same issues Ic an use parameters in Bi to switch between 1 measure at time on chart, however i want to compare 2 measures at a time (so actuals Vs forecast) per category.

Does anyone know hot to achive this without having to create 4 charts/show hie with bookmarks?