- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bar chart by days opens brackets is not working
Hello everyone,
I'm working on a dashboard to evaluate the performance of my IT support team. Initially, I had built a more basic version, but it had several pages and didn't include a calendar table or any metrics.
I have to admit, I've run into some issues with the metric visualizations because my data table has several dates: `date_entered`, `date_responded`, and `date_resolved`. Since I need a single date to filter the data and tell the story, I used the COALESCE function to create a new column called `days_for_analisys`. This column lets me include tickets that haven't been resolved yet by treating them as if they were resolved today.
This approach is necessary because I have a column called `days_open`, which shows how many days a ticket has been open, but it's grouped into day ranges (0-7, 8-14, 15-21, 22-28, and more than 28 days).
The goal is to display a chart like this one:
It works fine when there are no filters, meaning when I disable the interactions. But as soon as I enable them, the visualization stops working and only shows the category for completed tickets instead of all the different ranges.
For example, in August, I have several open tickets, but when I look at the chart, only the completed ones are displayed. I created a bar chart with `days_open` on the X-axis and `count_id` on the Y-axis, but it only shows one bar for completed tickets and doesn't include the others. It should display the tickets open for 22-28 days and another bar for those open for more than 28 days.
I can’t figure out where the problem is coming from, and since I don’t know that, I’m not sure how to fix it. Any chance someone could guide me or give me a clue about what might be going on?
I can share you my calendar table code or sample data to look at or even the relationships between the different tables.
Thank so much, I really appreciate any advice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ajdm2007 ,
Can you provide the sample data? What’s more, how is the expression to calculate the days open column ? How are the filters applied?
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Share the download link of the PBI file. Ensure the visual is already there and show the problem clearly.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I see no relation at all between your question in the original post and the data in your file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Ashish_Mathur ,
I'm a bit confused, the sample file I sent you contains the raw data, the filters and metrics are inside the project. I wonder if you expect me to send you the project?
I'm sorry but I don't really understand what you expect me to send you.
Thank you again,
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
09-14-2024 07:09 AM | |||
07-11-2024 09:22 AM | |||
09-11-2024 02:16 AM | |||
08-10-2024 05:05 AM | |||
04-14-2024 03:09 PM |
User | Count |
---|---|
126 | |
80 | |
59 | |
58 | |
44 |
User | Count |
---|---|
181 | |
121 | |
82 | |
70 | |
54 |