write DAX formula to return table

[abhaygawde]

Can any one help to write DAX formula that will return table single column value dynamicallly base on switch case?

If in slicer i chose filter value A then show record from A table and if i filter B then show records from B table

[BhaveshPatel]

Your explanation of the topic is too vague. We would like to see the data  with the expected output before proceeding ahead.

Can use HASONEVALUE function as well.

[abhaygawde]

X- AxisY AxisData model

Hi Bhavesh ,

Basically i have one requirement where i have 2 use measure as a axis.

I have 2 slicer X-Axis and Y-Axis . If i filter Business Group from X slicer and Actual Revenue from Y slicer then graph should Plot where X- axis values is from Bussiness group table and and Y- axis values from Acutal Revenue table.

Any help will be appriciated.

Thanks And Regards,

Abhay

[v-haibl-msft]

@abhaygawde

We cannot use measure as X-Axis, only table column or calculated column can be used as X-Axis. So in Power BI, X-Axis is static and can only be filtered but cannot be changed to different values.

Slicer values are come from a column in a table. Slicer is used to filter column values. Once we select a value in the slicer, the table which contains this column or related table will be filtered. You can take a look at this document to see when to use a slicer.

So we cannot use slicer to choose which column to be used in the X-Axis of visual chart. However we can use measure for Y-Axis. If the X-Axis is defined (e.g. Business Group), the Y-Axis result can be changed based on your selection in Y slicer (measure names are listed in Y slicer). You can refer to this blog for details.

To display three different things (business group, date, program) on X-Axis, we can only create three different visuals with different X-Axis, or create a Hierarchy with 3 levels and use drill down to see different X-Axis.

Best Regards,

Herbert