Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Constant Line Per Filter

Good afternoon I have a dashboard where I show the progress of enrollment according to the business line filter. As you can see, I have 3 constant lines to the x-axis M1, M2 and M3 which have to...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin ,

    Based on the information you have provided, you can follow the steps below:
    1. Create a table as a slicer.

     

    2.Add new measures.

     

    graduate = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "graduate", [sales_], BLANK () )

    high school1 = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "high school", [number_], BLANK () )

    high school2 = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "high school", [sales_], BLANK () )

     

     

    3.Put measures into the y-axis.

    Final output:

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Syndicate_Admin ,

Based on the information you have provided, you can follow the steps below:
1. Create a table as a slicer.

 

2.Add new measures.

 

graduate = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "graduate", [sales_], BLANK () )

high school1 = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "high school", [number_], BLANK () )

high school2 = 
IF ( SELECTEDVALUE ( Table2[Select] ) = "high school", [sales_], BLANK () )

 

 

3.Put measures into the y-axis.

Final output:

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.