Small Multiple - Unsync Axis

[Anonymous]

Hi, 

I am using Small Multiples. The scope of the Y-axis on the categories is different. Since all of the categories share the same axis, the last category doesn't show the spikes ...

1. Is there a fix to this problem?
2. Is there another visualization that I can use?
3. Is there a DAX fix to that?
   • I tried to use the switch() for each category to get the max and min of the Y-axis. but didn't work. 
   • I tried to use 4 separate line charts (since I want to show the top 4) but the user what to have the ability to select a couple of categories and dynamically see the top 4 features among the selected ones in 4 line charts. 
     With that requirement, I couldn't find a way to dynamically calculate the RANK and pass it as a filter to the line chart. 
     
     

Thank you in advance.


Here is the dynamic measure that calculates the feature rank based on the feature importance for the selected features by the user. 

Rank Feature Importance = 
IF(ISBLANK(SUM(Feature_Importance[Feature_Importance])),BLANK(),
    RANKX(
        ALLSELECTED(Feature_Importance)
        ,CALCULATE(
            SUM(Feature_Importance[Feature_Importance])
        )
    )
)

[Anonymous]

Hi @Anonymous ,

Did you try to apply the [Rank Feature Importance] to the visual-filter pane, set as "is less than 5" to show the top 4?

If it does not work, could you please share more detail information to help us clarify your scenario? Or  share me with your pbix file after removing sensitive data.

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

[Anonymous]

Thank you @Anonymous 

I Have created a sample PBIX file. Please see the screenshots and attached file for more information.



Please let me know if you have any questions.