Forum Discussion

Jero's avatar
Jero
Regular Visitor
8 years ago
Solved

Cross-highlighting based on measure

Hi,   I'm working on an error reporting project, which is based on the following data structure:     There are slicers for the department and the agent, and bar charts for the "category" a...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Jero,

     

    In your scenario, click one bar in in "Impact(s)" funnel chart cannot filter the other two bar charts. This is by design. Because you added serveral columns ([NonRecuperableLoss], [RecuperableLoss], [PotentialFutureLoss], [Gain] and [PotentialFutureGain]) into funnel chart, when you clicked one bar in funnel chart, actually, you were making column level filters. This operation didn't filter out any record row in other two charts. That is why the other two charts are not filtered, they supports row level filters.

     

    When you select [Gain] in funnel chart, all record rows are available.

     

     

    When you select [High] in column chart, only highlighted rows are available.

     

    An other example for your reference, if you create funnel chart like below.

     

    When clicking a bar in this chart (e.g. True), it can affect other two charts.

     

    Best regards,
    Yuliana Gu

     

Jero's avatar
Jero
Regular Visitor
8 years ago

Ok, I will try to provide some sample data in the next post. Being new to this forum, I do appreciate you correcting me if I'm going about things the wrong way.

 

 

As for the visualisations:

 


The "Error category" chart:

 

  • Axis: tblMain[ErrorCategory]
  • Value: %GT Count of tblMain[PrimaryKey]

 

 

The "Severity" chart: In order to display the different severities in their logical order, I have created a secondary table tblSortOrder, which has in one column (called SeveritySort) each of the four possible values (Low, Medium, High, Very High), in another column (called SortOrder) the corresponding sort order (1, 2, 3, 4). The Severity column of the tblMain table is linked with the SeveritySort column of the tblSortOrder table through a many-to-one relationship.

 

  • Axis: tblSortOrder[SeveritySort]
  • Value: %GT Count of tblMain[PrimaryKey]

 

 

The "Impact(s)" funnel chart:

 

Values:

 

  • CountNonRecuperableLoss = CALCULATE(COUNT(tblMain[PrimaryKey]);tblMain[NonRecuperableLoss]=TRUE())
  • CountRecuperableLoss = CALCULATE(COUNT(tblMain[PrimaryKey]);tblMain[RecuperableLoss]=TRUE())
  • CountPotentialFutureLoss = CALCULATE(COUNT(tblMain[PrimaryKey]);tblMain[PotentialFutureLoss]=TRUE())
  • CountGain = CALCULATE(COUNT(tblMain[PrimaryKey]);tblMain[Gain]=TRUE())
  • CountPotentialFutureGain = CALCULATE(COUNT(tblMain[PrimaryKey]);tblMain[PotentialFutureGain]=TRUE())