Visual level filters not working on line charts

[Anonymous]

Hi,

I have created a measure called Time Level and I am using this measure as a visual level filter in the line chart, when i choose the visual level filter of timelevel as "M" the chart is not dispalying values but when i remove the filter, it shows.

The visual level filter works fine for Day. Attaching the screenshots and the pbix file is Visual level filter

PBIx file path : https://kimberlyclark-my.sharepoint.com/:u:/r/personal/aneesh_vs_kcc_com/Documents/visual%20level%20...

without visual level filterVisual filter applied

[Anonymous · Accepted solution]

HI @Anonymous,

Please share some dummy data with same data structure and measure formula to help us clarify your scenario. They will help to test and coding formulas.

In addition, measure filter not able to achieve dynamic category level on your visual. I'd like to suggest you take a look at the following link to achieve dynamic attribute filter:

Dynamic Attributes In A Power BI Report 

Regards,

Xiaoxin Sheng

[Anonymous]

Select More options (...) > Edit report to open your report in Editing view.

Edit report button

Open the Visualizations and Filters pane and the Fields pane (if they're not already open).

Visualizations, Filters, and Fields panes

Select a visual to make it active. All the fields being used by the visual are in the Fields pane and also listed in the Filters pane, under the Visual level filters heading.

Select visual-level filters

At this point, we'll add a filter to a field already being used by the visualization.

Scroll down to the Visual level filters area and select the arrow to expand the field you'd like to filter. In this example, we'll filter StoreNumberName.

The arrow expands the filter

Set either Basic, Advanced, or Top N filtering controls. In this example, we'll search in Basic filtering for cha and select those five stores.

Search in Basic filtering

The visual changes to reflect the new filter. If you save your report with the filter, report readers will see the visual filtered to begin with, and can interact with the filter in Reading view, selecting or clearing values.

The filtered visual

When you use the filter on a field used in the visual where the field is aggregated (for example a sum, average, or count), you're filtering on the aggregated value in each data point. So, asking to filter the visual above where This Year Sales > 500000 means you would see only the 13 - Charleston Fashion Direct data point in the result. Filters on model measures always apply to the aggregated value of the data point.

[MFelix]

Hi @Anonymous ,

First of all the onedrive link you give is not public so I'm not abble to acces the file, but based on the screenshot you send the information is being filter however there is only M values for January.

How is your measure made and what is the expected result for the M calculation?

If you can share the file public I can try and check it out.