Forum Discussion

Lesveilleurs's avatar
Lesveilleurs
Frequent Visitor
2 years ago

Dynamic Line Chart with Selection and Its Higher L1 & L2 Categories'

Hi All, 

 

Thanks to anyone who takes a look.

I've been frustrated for a few days, trying many ways and checking numerous posts, parameter (not working).

The one below is close, but I'm still having trouble implementing the needs. 

Very close post 

 

Model Detail:

I'm working with a 3-tiered data model and have a measure called [_Line Chart] for a dynamic line chart.

 

[_Line Chart]

  • to use Table - Master2 as a control to ensure that all Tier 1 & Tier 2 numbers can be counted starting from Tier3's start date.
  • Table - Master is the original import data

Tiers : Here's how the tiers should display:

  • Tier 1: Always shown with its calculated number.
  • Tier 2: Appears as a single line when selected.
  • Tier 3: Also appears as a single line when selected.

Request:

There will be 2 slicers for Tier 2 and Tier 3.

  • Users can select Tier 2 from Slicer 1, then select the item they would like to see the trend for under Tier 3.
  •  
  • The line chart should show 4 lines:

2 from Tier 1 (assumed as United States-level numbers),

1 from Tier 2 (assumed as States-level numbers),

1 from Tier 3 (assumed as City-level numbers).

 

 Mock Test PBI Model 

Thanks in advance!!

Current view, selected with Ctrl.Expected Slicer

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Lesveilleurs ,
    Based on your description, you want to create a dynamic line chart to show the data in these hierarchies. Based on the pbix file you provided it is not possible to tell what your specific needs are, please provide your desired result as a screenshot so we can help you faster.

    Best regards,

    Albert He

     

    • Lesveilleurs's avatar
      Lesveilleurs
      Frequent Visitor

      Hi Albert,

      Many thanks for taking a look at my issue.

      I have attached a mockup of the expected result screenshot below.

       

      Expected resultresult logic