Forum Discussion
Constant X- axis for Bar chart
Hi,
I currently have a bar chart that is monitoring completion of forms which is dependent on location and department. People have 1 week to fill the form out, however, I would like to view this bar chart throughout the week to see who has completed/not completed the form. I would like to have all the locations labled on the x-axis, regardless if a data has been recorded. How would I do this?
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure = COUNTX( FILTER(ALL('Table'), 'Table'[location]=MAX('Table'[location])&&'Table'[completed/not completed]="Yes"), [User]) +0In Page1:
2. After creating a Page2, put [completed/not completed] in Filters, set = “Yes”.
3. Through the following link, set the visual object in Page2 to Tooltips.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
4. Result:
In the graph in Page1, moving the mouse to a Location will automatically display only the User with [completed/not completed] = “Yes”.
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
- amitchandak
Super User
Anonymous , based on what I got Either add +0 to the meausre
or use this option
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure = COUNTX( FILTER(ALL('Table'), 'Table'[location]=MAX('Table'[location])&&'Table'[completed/not completed]="Yes"), [User]) +0In Page1:
2. After creating a Page2, put [completed/not completed] in Filters, set = “Yes”.
3. Through the following link, set the visual object in Page2 to Tooltips.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
4. Result:
In the graph in Page1, moving the mouse to a Location will automatically display only the User with [completed/not completed] = “Yes”.
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
