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
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

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'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