Display separate line per hierarchy selection in slicer

[Anonymous]

Hi All,

I need to design the line chart in the dashboard which shows the finalized count per Banner, per Region, and per Store by Dates.

I having the Hierarchy slicer which showing Banner, Region, and Store.

My problem here is that When I have selected the Multiple Banners, the separate line will be shown by each Banner, In the next Region level, when I have selected the multiple Regions, the separate line will be shown by each region, and when I have select Multiple stores, a separate line will be shown by each store.

Elsewhen all selected in Slicer It will be showing Only a Single line.

What I have tried, (legend will be Stores)

Default Value =
IF(COUNTROWS(DISTINCT(ALLSELECTED(Orgunit[Stores]))) < COUNTROWS(DISTINCT(ALL(Orgunit[Stores]))),
SUM(AutoFinalised[AutoNew]),
CALCULATE(SUM(AutoFinalised[AutoNew]),ALL(Orgunit[Stores]))
)

It showing Single Line for Banner and Region but works fine for Stores, If I use Banner instead of stores, then it works fine for Banner(Legend will be Banner)

Please help me to solve the issue.

Thanks

[amitchandak]

@Anonymous , Can you share sample data and sample output.

[Anonymous]

Please find below the link to the dashboard

https://sparinformation-my.sharepoint.com/:u:/g/personal/atul_patil_sparinfosys_com/EQl4ad8CvwtNu6ek...

Here you can see the Slicer contains Banner, region, stores, and a line shart

Currently, it is showing a Single line for Banner and Region while selecting multiple banner and regions but works fine for stores(Separate line per store)

What I need: 

While we select multiple Banner from here, It should show separate line per Banner

While we select multiple Regions from here, It should show separate line per Region

While we select multiple Stores from here, It should show a separate line per Store.

Thanks

[Greg_Deckler]

@Anonymous - I downloaded your PBIX. I don't really think that is possible unless you radically change your data model to something like that found here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444

Even then, not certain. You might have to use buttons and bookmarks to switch between charts for different granularities.

[Greg_Deckler]

@Anonymous - Sorry, having trouble following this. Maybe sample data and some screen shots would help.

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.