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.
Long post as i think a little background will help understand the issue i am facing
i have a table for loans which has the following fields
1. App id
2. Created date
3. Funded date
4. Funder name
the below case 1 and 2 are already done , writing this here as thats the disired solution for the bar chart visual
Case 1: i want to count total application regardless if it was funded or not.
I am using count of app id for this. This is displayed in a card.
Case 2: i want the total funded count.
I am using count of funded date. This is displayed in a card
The logic required is that I need to see the counts based to created date and funded date.
Example
I have two slicers on my page
The total count should not be affected by the funded date slicer( I edited the interaction in the total count card) SOLVED
The funded count should not be affected by the created date slicer( I edited the interaction in the funded count card) SOLVED
Now i want a visual stacked chart by funder name
I want the total counts of each funder and funded counts of each funder and then also get the % funded
The logic for this I want to count funded applications by funded date regardless of their created date
And created date is counted regardless if it was funded
I was able to do this on a card as it only contains one value and i was able to edit interactions but I am unable to figure this out for a visual with multiple fields.
Is there a way to edit interactions of one field in a visual. Or is their any other solution
Thanks
I have two slicers on my page
Created date
Funded date
The total count should not be affected by the funded date slicer( I edited the interaction in the total count card) SOLVED
The funded count should not be affected by the created date slicer( I edited the interaction in the funded count card) SOLVED
The recommended approach is to have a Calendar table with an active relationship to Created Date and an inactive relationship to Funded date. Feed the slicer from the calendar. Create a measure with USERELATIONSHIP to calculate the funded numbers.
Covering 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 |
---|---|
114 | |
99 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |