11/27/2023 0 Comments Microsoft power bi desktop filter dataObjective is to allow users to select a 'Month' (for example 6), see their total target numbers and then also give them the option to see how much has been collected across 'DET_TRANSDATE' (for example Jul, Aug, Sep) against the total target numbers for the month. So when a user selects on 'Month'=6, 'DET_TRANSDATE' will show dates from Jul, Aug & so on. For example if Target 'Month" is 6, collections for same will happen in Jul, Aug, Sept and so on.Ĭolumn 'DET_TRANSDATE' shows the actual receipt dates. So when a user clicks on No, Yes or Select All, the target number should change (in the card & matrix visual) accordingly, sorry this was not clear in my initial post.Īlso my target numbers are always as of month-end, collections happen following month onwards. Sample pbix file I shared had only 'No' instances. ![]() The Target formula you gave works fine however in my report I also have a slicer "IntCo" with Yes and No entries. I am not sure if my query can be resolved with one table itself, thus, two tables were provided. The two tables that I am referring to (Collections & Receipts) are actually same table with identical data, only table name is different. Any help that could be provided would be greatly appreciated. click on below link to download the file) with two same tables. Hello, Im looking for a solution to implement filtering capability that will allow end-user to find individuals with matching skillset. Is the desired result possible to achieve using one single table or having two same tables and having some sort of relationship between them?Īttached, is the sample BI file (pls. Filter Data with Multiple Filter Conditions. ![]() It repeats the total receipts and total balance outstanding value on all rows for some reason. I have tried using a relationship however, the card visual seems to show correct data but the matrix visual does not filter data correctly for selected values in “Det_TransDate” slicer. ![]() The goal is to see how much has been collected at month-end vs after month-end+10 days. 1 ACCEPTED SOLUTION johnt75 Super User 03-04-2022 09:12 AM If you add the category from your bar chart as a drillthrough field on your data table page then users would be able to right-click on the elements of the bar chart and use drillthrough to go to the data page, which would be filtered by the category they chose. However, when I select the “Det_TransDate” (which is basically the receipts date), I’d like to see the respective collections and balance outstanding across those dates (this should be dynamic) however, the target for the month should not change in the card visual or the matrix visual. When I select “month”, I’d like to see the total target for the month in the card visual as well as the matrix visual. Hi, I have a table that contains collections target (for the months) and respective receipts information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |