Forum Discussion
Effective Dashboarding With Power BI
Hi OVILLAMIL,
I re-typed your issue in my post, for the others to reference, in case they have a better solution:
OP's question copied below:
"
Good day I have some queries that make regarding Power BI and desire me to partner with the following concerns. 1 When I am working on a project where it is important to define a ranking to a group of data within a database, I need to show me the 10 positions with higher values and the rest must be defined with the name other, I need you in one column I group the 10 positions with respective a column names and that the rest of data has the name of others finally need a type of graph a showing my previous to make it like this:
- I need a type of graph that shows me the following information in two years, how can I do?
- Power BI no possibility of conditional formatting such as Excel icons, gradients etc?
- Is there any way to implement the graphic Hierarchy Slicer search?
- As I can display the percentage of the pie chart?
- How can I select with mouse various objects on the canvas without choosing then one to one?
"
My reply
And I would try to answer some of your questions:
1 & 4:
To have the Pie chart display the precentage, we need a measure to calculated the precentage, then change the Measure data format to Precent, this would make it to display as precent in the Pie chart;
For top 10 groups, we could take use of switch function, calculate the 10 higher value and switch the rest with Others type.
For question 2,
Currently conditional formatting is available in Power BI Table Visuals, check the article: Conditional formatting in tables.
For question 3:
Please check the Slicer visual first: Tutorial: slicers in Power BI.
Well, I am not quite sure I understand all your questions in the right way, if there are any further concerns regarding the information above, please let me know.
And for question 5, currently I am not quite understand the meaning, which might need your further explanation.
Regards
3 Replies
v-micsh-msftMicrosoft Employee
Hi OVILLAMIL,
I re-typed your issue in my post, for the others to reference, in case they have a better solution:
OP's question copied below:
"
Good day I have some queries that make regarding Power BI and desire me to partner with the following concerns. 1 When I am working on a project where it is important to define a ranking to a group of data within a database, I need to show me the 10 positions with higher values and the rest must be defined with the name other, I need you in one column I group the 10 positions with respective a column names and that the rest of data has the name of others finally need a type of graph a showing my previous to make it like this:
- I need a type of graph that shows me the following information in two years, how can I do?
- Power BI no possibility of conditional formatting such as Excel icons, gradients etc?
- Is there any way to implement the graphic Hierarchy Slicer search?
- As I can display the percentage of the pie chart?
- How can I select with mouse various objects on the canvas without choosing then one to one?
"
My reply
And I would try to answer some of your questions:
1 & 4:
To have the Pie chart display the precentage, we need a measure to calculated the precentage, then change the Measure data format to Precent, this would make it to display as precent in the Pie chart;
For top 10 groups, we could take use of switch function, calculate the 10 higher value and switch the rest with Others type.
For question 2,
Currently conditional formatting is available in Power BI Table Visuals, check the article: Conditional formatting in tables.
For question 3:
Please check the Slicer visual first: Tutorial: slicers in Power BI.
Well, I am not quite sure I understand all your questions in the right way, if there are any further concerns regarding the information above, please let me know.
And for question 5, currently I am not quite understand the meaning, which might need your further explanation.
Regards
Ultima respuesta
Muchas gracias por su pronta respuesta sin embargo tengo las siguientes dudas en algunas respuestas.
- En la primera pregunta del porcentaje en la grafica de pie necesito me expliques con un ejemplo.
- La función SWITCH es una buena opción pero necesito que el calculo lo haga automatico y no entrar a modificar los datos en la función. Me explicas por favor con un ejemplo otra opción.
Agradezco tu atención y buen dia
Traducción
Thank you very much for your prompt response however I have the following concerns some answers.
- In the first question of the percentage in the graph Pie I need explain with an example.
- The SWITCH function is a good choice but need the automatic calculation do not enter and modify data in the function. You please me explain with an example other choice.
I appreciate your attention and good day
Oscar Villamil
- v-micsh-msft
Hi OVILLAMIL,
Pie chart is similar to Doughnut charts in Power BI, we may take a look at the article below as a reference:
Tutorial: Doughnut charts in Power BI
The following is my testing example:
If Switch function is not helpful, we may consider take use of IF function.
Besides, if sharing some data example is available, then we may suggest a more suitable DAX expression.
If you need any further help, please feel free to post back.
Regards
