Forum Discussion
Tachometer dynamic target setting
1. Make sure that the data types in Power BI for R2 and R3 are set to not aggregate by default. In your Power BI data model, select the columns R2 and R3, then in the Modeling tab, set the 'Default Summarization' to 'Don't Summarize'. This change will prevent Power BI from automatically aggregating these columns in visuals.
2. To display the exact values for each machine without any aggregation, drag a Table visual onto your report canvas. Place the 'Workstationname' in the first column, then add 'R2' and 'R3' to the table. This setup should display the values as they appear in your Excel sheet without any summation or averaging.
3. Ensure that when you import the Excel data, you are not inadvertently summarizing or changing the data in the query editor. Verify this by going through the steps in Power Query and looking at each applied step to confirm that no aggregation functions are applied upon import.
4. After making changes in your Excel source, make sure to refresh your data in Power BI to reflect the updated values.
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
Hi AnalyticsWizard and Anonymous
i have tried both the technique and apply it on tachometer but when i place that column on R2 and R3 its aggrigate it and gives aggregated result and i have taken thise records from excel only i have created the table and gives target to it . As tachometer shows colour on r2 and r3 thats why i ahve set range target for them but target range for each machine i snot changing.
if you have any other ideas please share with me.
thanks
sanket
