Forum Discussion

abhaygawde's avatar
abhaygawde
Frequent Visitor
9 years ago

write DAX formula to return table

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...
Need Help
abhaygawde's avatar
abhaygawde
Frequent Visitor
9 years ago

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's avatar
v-haibl-msft
Microsoft Employee
9 years ago

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