Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to 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
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
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.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |