Find & Replace with Wildcards
April 27, 2021
Excel’s 5 Useful but rarely used Functions
September 30, 2021
1.While selecting the table names to get data we need to carefully check the small boxes. It can be a little difficult at times.
VOILA!!! We have a solution.
2. Add Mail Icon:
a. Select a text box
b. Type “*”
c. Select the star and change the font type to Windings
d. Automatically the mail icon appears. Add mail link to it
3. If Power BI becomes unresponsive then minimize and maximize the BI page. This works most of the time.
4. Group Visuals together:
a. Press CTRL key and select the visuals to be grouped
b. Right-click and select Group > Group
c. Go to formats and have a common background colour
Also asymmetrical visuals and text boxes can be grouped together to form a symmetrical background shape.
5. Have a pivot style layout in power bi is now just a click away.
a. Select a matrix visual
b. Select the column to add
c. Go to Format > Row Headers
d. Stepped Layout > ON / OFF
We can increase or decrease the indentation.
Contributor:Shruthi Iyengar
Qualifications: B.Sc. Statistics (Hons), Pursuing Actuarial Science
Hello, I am an Excel and BI enthusiast and love working with numbers. I develop Excel modules for corporate training. Apart from this, I love to do Yoga and Meditation for a strong body and a healthy mind.
