Forum Discussion
Monthly UPtime dashboard
Hi I have data in excel in below format
| Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | |
| Link1 | 90% | 89% | 88% | 86% | 86% | 90% |
| Link2 | 90% | 89% | 88% | 86% | 86% | 90% |
| Link 3 | 90% | 88% | 86% | 73% | 86% | 72% |
I am trying to model in powerbi using matrix. But since Months coming as diffrent columns, facing difficulty in creating SLicer, monthwise. Getting the result after making pivot columns (for all months) but issue is when new month data comes, how this will be auto updated ?
Pls help
Hi, rjithesh
As you mentioned, I want to make a slicer of the month and be able to update it automatically. First, you need to import your original table into Power Query, then create a reference table, and then unpivot the month column of the application table. Go back to Power BI and create a slicer using the month column of the reference table.
Here's how to do it:
Create a matrix in the Power BI matrix using the type column of the original table and the attribute column of the reference table, and then use the value field of the app table as the value of the matrix:
Regarding automatic update, when you add a new month column to the original table, you only need to refresh the original dataset to automatically update the month of the slicer, for example, add the 24-Nov column.
That's what can be done so far. I've provided the PBIX file used this time below.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, rjithesh
As you mentioned, I want to make a slicer of the month and be able to update it automatically. First, you need to import your original table into Power Query, then create a reference table, and then unpivot the month column of the application table. Go back to Power BI and create a slicer using the month column of the reference table.
Here's how to do it:
Create a matrix in the Power BI matrix using the type column of the original table and the attribute column of the reference table, and then use the value field of the app table as the value of the matrix:
Regarding automatic update, when you add a new month column to the original table, you only need to refresh the original dataset to automatically update the month of the slicer, for example, add the 24-Nov column.
That's what can be done so far. I've provided the PBIX file used this time below.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a ton Jianpeng Li....Issue Resolved !!!!!
