The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi,
When I enter the report in default settings my cluster column shows the following values:
After using the slicer on the report page it will show the correct numbers.
However, when leaving the report (with activated slicer) and re-entering it. The cluster column will show the following values:
I don't understand where this is coming from. I can solve it by using the "reset to default" button.
However, it is not how it is supposed to function.
Please ask if anything is unclear.
Kind regards,
Guido
Hi @Anonymous,
Could you please share you sample data of your table to me and tell us the version of your Power BI Desktop?
As based on my test, everything goes well and I cannot reproduce your issue in Power BI Service.
Regards,
Frank
How I created the table can also be found at this topic: http://community.powerbi.com/t5/Desktop/Create-column-filled-with-measures/m-p/325596#M145213
The last update of my power BI desktop was after the June 2018 Update.
Sample data:
Representative (used in the slicer)
Representative |
Representative A |
Representative B |
Representative C |
Visit reports:
Rep code | Company | Type |
1111 | Company A | Acquisitie |
1111 | Company B | ROS |
1111 | Company C | Relatie beheer |
1111 | Company D | Contractverlenging |
1111 | Company E | Acquisitie |
1111 | Company F | ROS |
2222 | Company G | Relatie beheer |
2222 | Company H | Acquisitie |
2222 | Company I | Acquisitie |
2222 | Company J | ROS |
2222 | Company K | Relatie beheer |
2222 | Company L | Acquisitie |
3333 | Company M | Relatie beheer |
3333 | Company N | Acquisitie |
3333 | Company O | Contractverlenging |
3333 | Company P | ROS |
3333 | Company Q | Acquisitie |
3333 | Company R | Relatie beheer |
Translate:
Representative | Code |
Representative A | 1111 |
Representative B | 2222 |
Representative C | 3333 |
Goals:
Representative | Type | Goal |
Representative A | Acquisitie | 20 |
Representative A | ROS | 10 |
Representative A | Relatie beheer | 30 |
Representative A | Contractverlenging | 5 |
Representative B | Acquisitie | 20 |
Representative B | ROS | 10 |
Representative B | Relatie beheer | 30 |
Representative B | Contractverlenging | 5 |
Representative C | Acquisitie | 20 |
Representative C | ROS | 10 |
Representative C | Relatie beheer | 30 |
Representative C | Contractverlenging | 5 |
Type
Type |
Acquisitie |
ROS |
Relatie beheer |
Contractverlenging |
I am using the clustered column chart:
Axis:
- 'Type' [Type]
Value:
- Calculated measure (Count visit):
CALCULATE(COUNT('Visit report' [Company]); USERELATIONSHIP('translate' [Code];'Visit report' [Rep Code]))
- Calculate column (Target PM)
('Goals' [Goal]/12)*MONTH(TODAY())
I don't know how to sent a pbix file on here. Otherwise I can create a sample file.
Hope you can help me any further!
Kind regards,
Guido
Hi @Anonymous,
I used this version 2.36.4434.362 64-bit (June 2016) to make a test using the data as you shared. Is the version Number same as yours? Unfortunately, I still cannot reproduce the issue. So you can ask for help to open a ticket from here.
Regards,
Frank
Allright, Thanks for your help!
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.